APPS.BEN_PURGE_BCKDT_VOIDED dependencies on BEN_PER_IN_LER

Line 705: from ben_per_in_ler pil

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
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'

Line 712: from ben_per_in_ler pil

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
713: where pil.PTNL_LER_FOR_PER_ID = p.PTNL_LER_FOR_PER_ID);
714: end if;
715: --
716: ben_batch_utils.write(p_text => ' No. of Voided Potentials Deleted = ' || sql%rowcount );

Line 729: and not exists ( select 1 from ben_per_in_ler p

725: -- May be we shud plug in the ben post process calll here
726: --
727: delete from ben_elig_cvrd_dpnt_f t
728: where business_group_id = p_business_group_id
729: and not exists ( select 1 from ben_per_in_ler p
730: where p.per_in_ler_id = t.per_in_ler_id ) ;
731:
732: delete from ben_pl_bnf_f t
733: where business_group_id = p_business_group_id

Line 734: and not exists ( select 1 from ben_per_in_ler p

730: where p.per_in_ler_id = t.per_in_ler_id ) ;
731:
732: delete from ben_pl_bnf_f t
733: where business_group_id = p_business_group_id
734: and not exists ( select 1 from ben_per_in_ler p
735: where p.per_in_ler_id = t.per_in_ler_id );
736: --
737: -- End the process.
738: --

Line 1120: benutils.write(p_text => 'Ben_per_in_ler '||to_char(g_per_in_ler_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);
1124: --

Line 1268: from ben_per_in_ler pil

1264: l_from_ocrd_date date;
1265: --
1266: cursor c_per_in_ler_1 is
1267: select per_in_ler_id
1268: from ben_per_in_ler pil
1269: where pil.person_id = p_person_id
1270: and pil.business_group_id = p_business_group_id
1271: and pil.per_in_ler_stat_cd in ('BCKDT','VOIDD')
1272: and (p_life_event_id is null or pil.ler_id = p_life_event_id)

Line 1284: from ben_per_in_ler pil

1280: ler.effective_end_date));
1281: --
1282: cursor c_per_in_ler_2 is
1283: select per_in_ler_id
1284: from ben_per_in_ler pil
1285: where pil.person_id = p_person_id
1286: and pil.business_group_id = p_business_group_id
1287: and pil.per_in_ler_stat_cd in ('VOIDD')
1288: and (p_life_event_id is null or pil.ler_id = p_life_event_id)

Line 1309: type per_in_tab is table of ben_per_in_ler.per_in_ler_id%type

1305: from ben_prtt_enrt_rslt_f pen
1306: where pen.per_in_ler_id = p_per_in_ler_id
1307: and pen.prtt_enrt_rslt_stat_cd in ('BCKDT','VOIDD');
1308: --
1309: type per_in_tab is table of ben_per_in_ler.per_in_ler_id%type
1310: index by binary_integer;
1311: t_per_in_ler per_in_tab;
1312: t_per_in_ler2 per_in_tab;
1313: t_elctbl_chc per_in_tab;

Line 1510: from ben_per_in_ler pil

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';
1513: --
1514: forall i in 1..t_per_in_ler2.last

Line 1515: delete from ben_per_in_ler

1511: where per_in_ler_id = t_per_in_ler2(i))
1512: and ptnl_ler_for_per_stat_cd = 'VOIDD';
1513: --
1514: forall i in 1..t_per_in_ler2.last
1515: delete from ben_per_in_ler
1516: where per_in_ler_id = t_per_in_ler2(i);
1517: end if;
1518: --
1519: end if;