APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_PER_IN_LER

Line 657: from ben_per_in_ler pil,

653: -- CWB Changes.
654: --
655: cursor c_per_in_ler is
656: select pil.lf_evt_ocrd_dt, ler.typ_cd
657: from ben_per_in_ler pil,
658: ben_ler_f ler
659: where pil.per_in_ler_id = l_per_in_ler_id
660: and pil.ler_id = ler.ler_id
661: and p_effective_date between ler.effective_start_date and

Line 670: from ben_per_in_ler pil,

666: -- CWB Changes.
667: --
668: cursor c_procd_dt_pil is
669: select pil.procd_dt
670: from ben_per_in_ler pil,
671: ben_ler_f ler
672: where pil.person_id = p_person_id
673: and pil.per_in_ler_id <> l_per_in_ler_id
674: and pil.per_in_ler_stat_cd = 'PROCD'

Line 683: from ben_per_in_ler pil,

679: order by lf_evt_ocrd_dt desc;
680:
681: cursor c_procd_dt_pil_cwb is
682: select pil.procd_dt
683: from ben_per_in_ler pil,
684: ben_ler_f ler
685: where pil.person_id = p_person_id
686: and pil.per_in_ler_id <> l_per_in_ler_id
687: and pil.per_in_ler_stat_cd = 'PROCD'

Line 741: ben_per_in_ler pil

737: --
738: cursor c_pen_max_esd (v_prtt_enrt_rslt_id in number) is
739: select pen.effective_end_date,pen.object_version_number
740: from ben_prtt_enrt_rslt_f pen,
741: ben_per_in_ler pil
742: where prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
743: and pen.business_group_id = p_business_group_id
744: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')
745: and pen.per_in_ler_id = pil.per_in_ler_id