DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_ELCTBL_CHC_CTFN

Line 1108: benutils.write(p_text => 'Ben_elctbl_chc_ctfn '||to_char(g_elctbl_chc_ctfn_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));
1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_rows));
1112: benutils.write(p_text => 'Ben_prtt_rt_val '||to_char(g_prtt_rt_rows));

Line 1406: delete from ben_elctbl_chc_ctfn

1402: where elig_per_elctbl_chc_id = t_elctbl_chc(i));
1403: g_enrt_prem_rows := g_enrt_prem_rows + sql%rowcount;
1404:
1405: forall i in 1..t_elctbl_chc.last
1406: delete from ben_elctbl_chc_ctfn
1407: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1408: g_elctbl_chc_ctfn_rows := g_elctbl_chc_ctfn_rows + sql%rowcount;
1409:
1410: forall i in 1..t_elctbl_chc.last

Line 1411: delete from ben_elctbl_chc_ctfn

1407: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1408: g_elctbl_chc_ctfn_rows := g_elctbl_chc_ctfn_rows + sql%rowcount;
1409:
1410: forall i in 1..t_elctbl_chc.last
1411: delete from ben_elctbl_chc_ctfn
1412: where enrt_bnft_id in
1413: (select enrt_bnft_id
1414: from ben_enrt_bnft
1415: where elig_per_elctbl_chc_id = t_elctbl_chc(i));