CREATE TABLE reward_pool ( 
    dt_rp_id          NUMBER(24, 0), 
    dt_rp_prog_id     NUMBER(10, 0), 
    dt_rp_tp_id       VARCHAR2(18), 
    dt_rp_type_code   NUMBER(10, 0), 
    dt_rp_value       FLOAT(126) 
)

create or replace TYPE rec_dt_reward_pool_row as object ( 
    dt_rp_id          NUMBER(24, 0), 
    dt_rp_prog_id     NUMBER(10, 0), 
    dt_rp_tp_id       VARCHAR2(18), 
    dt_rp_type_code   NUMBER(10, 0), 
    dt_rp_value       FLOAT(126) 
);

create or replace TYPE tab_dt_reward_pool IS 
    TABLE OF rec_dt_reward_pool_row; 

create or replace procedure test_reward_type 
is 
    p_mic_reward_tab tab_dt_reward_pool; 
begin 
        SELECT 
        rec_dt_reward_pool_row(dt_rp_id, dt_rp_prog_id, dt_rp_tp_id, dt_rp_type_code, dt_rp_value) 
        BULK COLLECT 
        INTO p_mic_reward_tab 
        FROM 
            reward_pool;  
end;