APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_PTNL_LER_FOR_PER

Line 688: delete from ben_ptnl_ler_for_per

684: benutils.write(p_text => benutils.g_banner_minus);
685: if p_delete_ptnl_life_evt = 'Y' and p_delete_life_evt = 'Y'
686: then
687: --
688: delete from ben_ptnl_ler_for_per
689: where ptnl_ler_for_per_stat_cd = 'VOIDD'
690: and business_group_id = p_business_group_id
691: and (p_life_event_id is null or ler_id = p_life_event_id)
692: and (p_person_id is null or person_id = p_person_id);

Line 700: delete from ben_ptnl_ler_for_per p

696: ben_batch_utils.write(p_text => ' No. of Voided Potentials Deleted = ' || sql%rowcount );
697: elsif p_delete_ptnl_life_evt = 'Y' and p_delete_life_evt = 'N'
698: then
699: If p_person_id is not null then
700: delete from ben_ptnl_ler_for_per p
701: where p.ptnl_ler_for_per_stat_cd = 'VOIDD'
702: and p.business_group_id = p_business_group_id
703: and p.person_id = p_person_id
704: and not exists ( select 1

Line 708: delete from ben_ptnl_ler_for_per p

704: and not exists ( select 1
705: from ben_per_in_ler pil
706: where pil.PTNL_LER_FOR_PER_ID = p.PTNL_LER_FOR_PER_ID);
707: else
708: delete from ben_ptnl_ler_for_per p
709: where p.ptnl_ler_for_per_stat_cd = 'VOIDD'
710: and p.business_group_id = p_business_group_id
711: and not exists ( select 1
712: from ben_per_in_ler pil

Line 1121: benutils.write(p_text => 'Ben_ptnl_ler_for_per '||to_char(g_ptnl_ler_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);
1124: --
1125: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);

Line 1508: delete from ben_ptnl_ler_for_per

1504: g_le_clsn_rows := g_le_clsn_rows + sql%rowcount;
1505: --
1506: if p_delete_life_evt = 'Y' then
1507: forall i in 1..t_per_in_ler2.last
1508: delete from ben_ptnl_ler_for_per
1509: where ptnl_ler_for_per_id = (select ptnl_ler_for_per_id
1510: from ben_per_in_ler pil
1511: where per_in_ler_id = t_per_in_ler2(i))
1512: and ptnl_ler_for_per_stat_cd = 'VOIDD';