eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ELIG_DPNT_API dependencies on BEN_PER_IN_LER

Line 1440: ben_per_in_ler pil

1436: epe.prtt_enrt_rslt_id,
1437: egd.object_version_number
1438: from ben_elig_dpnt egd,
1439: ben_elig_per_elctbl_chc epe,
1440: ben_per_in_ler pil
1441: where egd.elig_dpnt_id = p_elig_dpnt_id
1442: and egd.business_group_id = p_business_group_id
1443: and egd.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
1444: and egd.per_in_ler_id = pil.per_in_ler_id

Line 2076: ben_per_in_ler pil

2072: AND p_effective_date between typ.effective_start_date
2073: and typ.effective_end_date
2074: AND EXISTS(SELECT null
2075: FROM ben_crt_ordr crt,
2076: ben_per_in_ler pil
2077: WHERE crt.crt_ordr_typ_cd IN ('QMCSO','QDRO')
2078: AND crt.person_id = pen.person_id
2079: AND (crt.pl_id = pln.pl_id or crt.pl_typ_id = typ.pl_typ_id)
2080: AND crt.business_group_id = p_business_group_id

Line 2178: ben_per_in_ler pil

2174: cursor c_pdp is
2175: select egd.*
2176: from ben_elig_dpnt egd,
2177: ben_elig_cvrd_dpnt_f pdp,
2178: ben_per_in_ler pil
2179: where pdp.elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
2180: and pdp.per_in_ler_id = egd.per_in_ler_id
2181: and pdp.elig_cvrd_dpnt_id = egd.elig_cvrd_dpnt_id
2182: and pdp.dpnt_person_id = egd.dpnt_person_id

Line 2228: ben_per_in_ler pil

2224: select egd.*
2225: from ben_elig_dpnt egd,
2226: ben_elig_cvrd_dpnt_f pdp,
2227: ben_prtt_enrt_rslt_f pen,
2228: ben_per_in_ler pil
2229: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2230: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2231: and pdp.dpnt_person_id = p_dpnt_person_id
2232: and pdp.per_in_ler_id = egd.per_in_ler_id

Line 2306: ben_per_in_ler pil,

2302: select egd.elig_dpnt_id
2303: from ben_elig_dpnt egd,
2304: ben_elig_per_opt_f epo,
2305: ben_elig_per_f pep,
2306: ben_per_in_ler pil,
2307: ben_oipl_f oipl
2308: where egd.dpnt_person_id = c_dpnt_person_id
2309: and egd.elig_per_opt_id = epo.elig_per_opt_id
2310: and egd.elig_per_id = epo.elig_per_id

Line 2335: ben_per_in_ler pil,

2331: )
2332: is
2333: select egd.elig_dpnt_id
2334: from ben_elig_dpnt egd,
2335: ben_per_in_ler pil,
2336: ben_elig_per_f pep
2337: where egd.dpnt_person_id = c_dpnt_person_id
2338: and egd.elig_per_opt_id is null
2339: and egd.elig_per_id = pep.elig_per_id

Line 2674: ben_per_in_ler pil

2670:
2671: cursor c_chk_enrt (c_rltp_start_date date,c_rltp_end_date date) is
2672: select 'Y' from ben_elig_cvrd_dpnt_f ecd,
2673: ben_prtt_enrt_rslt_f pen,
2674: ben_per_in_ler pil
2675: where ecd.dpnt_person_id = p_dpnt_person_id
2676: and ecd.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
2677: and pen.prtt_enrt_rslt_stat_cd is null
2678: and ecd.per_in_ler_id = pil.per_in_ler_id