DBA Data[Home] [Help]

APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_PRMRY_CARE_PRVDR_F

Line 1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));

1115: benutils.write(p_text => 'Ben_prtt_enrt_ctfn_prvdd_f '||to_char(g_ctfn_prvdd_rows));
1116: benutils.write(p_text => 'Ben_elig_cvrd_dpnt_f '||to_char(g_elig_cvrd_dpnt_rows));
1117: benutils.write(p_text => 'Ben_prtt_enrt_rslt_f '||to_char(g_prtt_enrt_rslt_rows));
1118: benutils.write(p_text => 'Ben_pl_bnf_f '||to_char(g_pl_bnf_rows));
1119: benutils.write(p_text => 'Ben_prmry_care_prvdr_f '||to_char(g_prmry_care_rows));
1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_rows));
1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_rows));
1122: benutils.write(p_text => 'Ben_le_clsn_n_rstr '||to_char(g_le_clsn_rows));
1123: benutils.write(p_text => benutils.g_banner_minus);

Line 1494: delete from ben_prmry_care_prvdr_f

1490: g_pl_bnf_rows := g_pl_bnf_rows + sql%rowcount;
1491: --
1492: forall i in 1..t_rslt.last
1493: --
1494: delete from ben_prmry_care_prvdr_f
1495: where prtt_enrt_rslt_id = t_rslt(i);
1496: g_prmry_care_rows := g_prmry_care_rows + sql%rowcount;
1497: --
1498: end if;