TYPE rec IS RECORD ( proj   AV_ACTIVITY.proj%TYPE,
                         act    AV_ACTIVITY.act%TYPE );

    TYPE object_table_type is TABLE OF rec INDEX BY BINARY_INTEGER;
    temp_ass_rn object_table_type;

for c1_rec in (    select distinct PROJECT_NAME , ACTIVITY_NAME
                    from adm.dup_memo_project
                    where act_res_status = 'ASSIGNED'
                    order by project_name , activity_name
                )
            loop
                        v_cnt_temp_ass_rn                   := 1 + temp_ass_rn.count;
                        temp_ass_rn(v_cnt_temp_ass_rn).proj := c1_rec.project_name;
                        temp_ass_rn(v_cnt_temp_ass_rn).act  := c1_rec.activity_name;

            end loop;

dbms_output.put_line(temp_ass_rn.count);

                        temp_ass_rn(v_cnt_temp_ass_rn).proj := c1_rec.project_name;
                        temp_ass_rn(v_cnt_temp_ass_rn).act  := c1_rec.activity_name;