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