APPS.BEN_NEWLY_INELIGIBLE dependencies on BEN_PER_IN_LER

Line 659: from ben_per_in_ler pil,

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

Line 672: from ben_per_in_ler pil,

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

Line 685: from ben_per_in_ler pil,

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

Line 743: ben_per_in_ler pil

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