498: -- before deleting enrt_rt - capture the data into pl/sql table
499: /*
500: for i in c_enrt_rt loop
501: --
502: ben_manage_life_events.g_enrt_rt_tbl(l_count).enrt_rt_id := i.enrt_rt_id;
503: ben_manage_life_events.g_enrt_rt_tbl(l_count).acty_base_rt_id := i.acty_base_rt_id;
504: ben_manage_life_events.g_enrt_rt_tbl(l_count).prtt_rt_val_id := i.prtt_rt_val_id;
505: l_count := l_count + 1;
506: --
499: /*
500: for i in c_enrt_rt loop
501: --
502: ben_manage_life_events.g_enrt_rt_tbl(l_count).enrt_rt_id := i.enrt_rt_id;
503: ben_manage_life_events.g_enrt_rt_tbl(l_count).acty_base_rt_id := i.acty_base_rt_id;
504: ben_manage_life_events.g_enrt_rt_tbl(l_count).prtt_rt_val_id := i.prtt_rt_val_id;
505: l_count := l_count + 1;
506: --
507: end loop;
500: for i in c_enrt_rt loop
501: --
502: ben_manage_life_events.g_enrt_rt_tbl(l_count).enrt_rt_id := i.enrt_rt_id;
503: ben_manage_life_events.g_enrt_rt_tbl(l_count).acty_base_rt_id := i.acty_base_rt_id;
504: ben_manage_life_events.g_enrt_rt_tbl(l_count).prtt_rt_val_id := i.prtt_rt_val_id;
505: l_count := l_count + 1;
506: --
507: end loop;
508: --
509: */
510: l_count := 1;
511: for i in c_pil_popl loop
512: --
513: ben_manage_life_events.g_pil_popl_tbl(l_count).pgm_id := i.pgm_id;
514: ben_manage_life_events.g_pil_popl_tbl(l_count).pl_id := i.pl_id;
515: ben_manage_life_events.g_pil_popl_tbl(l_count).elcns_made_dt := i.elcns_made_dt;
516: l_count := l_count + 1;
517: --
510: l_count := 1;
511: for i in c_pil_popl loop
512: --
513: ben_manage_life_events.g_pil_popl_tbl(l_count).pgm_id := i.pgm_id;
514: ben_manage_life_events.g_pil_popl_tbl(l_count).pl_id := i.pl_id;
515: ben_manage_life_events.g_pil_popl_tbl(l_count).elcns_made_dt := i.elcns_made_dt;
516: l_count := l_count + 1;
517: --
518: end loop;
511: for i in c_pil_popl loop
512: --
513: ben_manage_life_events.g_pil_popl_tbl(l_count).pgm_id := i.pgm_id;
514: ben_manage_life_events.g_pil_popl_tbl(l_count).pl_id := i.pl_id;
515: ben_manage_life_events.g_pil_popl_tbl(l_count).elcns_made_dt := i.elcns_made_dt;
516: l_count := l_count + 1;
517: --
518: end loop;
519: --