DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_ENRT_PREM

Line 1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));

1102: benutils.write(p_text => '---------- -------------------');
1103: benutils.write(p_text => 'Ben_elig_per_f '||to_char(g_elig_rows));
1104: benutils.write(p_text => 'Ben_elig_per_opt_f '||to_char(g_elig_per_rows));
1105: benutils.write(p_text => 'Ben_enrt_rt '||to_char(g_enrt_rt_rows));
1106: benutils.write(p_text => 'Ben_enrt_prem '||to_char(g_enrt_prem_rows));
1107: benutils.write(p_text => 'Ben_enrt_bnft '||to_char(g_enrt_bnft_rows));
1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_rows));
1109: benutils.write(p_text => 'Ben_elig_per_elctbl_chc '||to_char(g_elig_per_elctbl_chc_rows));
1110: benutils.write(p_text => 'Ben_pil_elctbl_chc_popl '||to_char(g_pil_elctbl_chc_popl_rows));

Line 1393: delete from ben_enrt_prem

1389: where elig_per_elctbl_chc_id = t_elctbl_chc(i));
1390: g_enrt_rt_rows := g_enrt_rt_rows + sql%rowcount;
1391:
1392: forall i in 1..t_elctbl_chc.last
1393: delete from ben_enrt_prem
1394: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1395: g_enrt_prem_rows := g_enrt_prem_rows + sql%rowcount;
1396:
1397: forall i in 1..t_elctbl_chc.last

Line 1398: delete from ben_enrt_prem

1394: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1395: g_enrt_prem_rows := g_enrt_prem_rows + sql%rowcount;
1396:
1397: forall i in 1..t_elctbl_chc.last
1398: delete from ben_enrt_prem
1399: where enrt_bnft_id in
1400: (select enrt_bnft_id
1401: from ben_enrt_bnft
1402: where elig_per_elctbl_chc_id = t_elctbl_chc(i));