DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_ELIG_DPNT

Line 1111: benutils.write(p_text => 'Ben_elig_dpnt '||to_char(g_elig_dpnt_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));
1113: benutils.write(p_text => 'Ben_prtt_enrt_actn_f '||to_char(g_prtt_enrt_actn_rows));
1114: benutils.write(p_text => 'Ben_prtt_prem_f '||to_char(g_prtt_prem_rows));
1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));

Line 1442: delete from ben_elig_dpnt

1438: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1439: g_elig_per_elctbl_chc_rows := g_elig_per_elctbl_chc_rows + sql%rowcount;
1440: --
1441: forall i in 1..t_elctbl_chc.last
1442: delete from ben_elig_dpnt
1443: where elig_per_elctbl_chc_id = t_elctbl_chc(i);
1444: g_elig_dpnt_rows := g_elig_dpnt_rows + sql%rowcount;
1445:
1446: end if;