APPS.BEN_ELPRO_CHECK_ELIGIBILITY dependencies on BEN_PER_IN_LER

Line 111: ben_per_in_ler pil

107: ben_ptip_f ctp,
108: ben_pl_regn_f prg,
109: ben_regn_f reg,
110: ben_elig_per_f epo,
111: ben_per_in_ler pil
112: where pln.pl_id = cpp.pl_id
113: and pln.business_group_id = c_business_group_id
114: and c_effective_date
115: between pln.effective_start_date

Line 166: ben_per_in_ler pil

162: is
163: select /*+ bendtlep.check_elig_othr_ptip_prte.c1 */
164: null
165: from ben_elig_per_f epo,
166: ben_per_in_ler pil
167: where epo.person_id = c_person_id
168: and epo.pl_id is null
169: and epo.ptip_id = c_ptip_id
170: and epo.business_group_id = c_business_group_id

Line 388: ben_per_in_ler pil

384: ben_plip_f cpp,
385: ben_ptip_f ctp,
386: ben_elig_per_f epo,
387: ben_elig_dpnt edp,
388: ben_per_in_ler pil
389: --per_contact_relationships pcr -- bug 6811004 fix reverted for bug 9900419
390: where pln.pl_id = cpp.pl_id
391: and pln.business_group_id = c_bgp_id
392: and c_eff_date

Line 415: ,ben_per_in_ler pil2

411: and epo.elig_flag = 'Y'
412: and edp.dpnt_inelig_flag = 'N'
413: and edp.create_dt = (select max(edp2.create_dt)
414: from ben_elig_dpnt edp2
415: ,ben_per_in_ler pil2
416: where edp2.dpnt_person_id = edp.dpnt_person_id
417: and edp2.elig_per_id = epo.elig_per_id
418: and pil2.per_in_ler_id(+)=edp2.per_in_ler_id
419: and pil2.business_group_id(+)=edp2.business_group_id

Line 431: from ben_per_in_ler pil3

427: or pil.per_in_ler_stat_cd is null
428: )
429: -- bug 14757304
430: and pil.lf_evt_ocrd_dt = (select max(pil3.lf_evt_ocrd_dt)
431: from ben_per_in_ler pil3
432: ,ben_elig_dpnt edp3
433: ,ben_elig_per_elctbl_chc epe -- 16218534
434: where pil3.per_in_ler_id = edp3.per_in_ler_id
435: and edp3.dpnt_person_id = c_person_id