APPS.BEN_ELIG_DPNT_API dependencies on BEN_ELIG_PER_F

Line 2298: ben_elig_per_f pep,

2294: is
2295: select egd.elig_dpnt_id
2296: from ben_elig_dpnt egd,
2297: ben_elig_per_opt_f epo,
2298: ben_elig_per_f pep,
2299: ben_per_in_ler pil,
2300: ben_oipl_f oipl
2301: where egd.dpnt_person_id = c_dpnt_person_id
2302: and egd.elig_per_opt_id = epo.elig_per_opt_id

Line 2329: ben_elig_per_f pep

2325: is
2326: select egd.elig_dpnt_id
2327: from ben_elig_dpnt egd,
2328: ben_per_in_ler pil,
2329: ben_elig_per_f pep
2330: where egd.dpnt_person_id = c_dpnt_person_id
2331: and egd.elig_per_opt_id is null
2332: and egd.elig_per_id = pep.elig_per_id
2333: and pep.pl_id = c_pl_id

Line 2352: ben_elig_per_f pep

2348: is
2349: select epo.elig_per_opt_id,
2350: epo.elig_per_id
2351: from ben_elig_per_opt_f epo,
2352: ben_elig_per_f pep
2353: where epo.per_in_ler_id = c_per_in_ler_id
2354: and c_effective_date between
2355: epo.effective_start_date and epo.effective_end_date
2356: and epo.elig_per_id = pep.elig_per_id

Line 2567: ben_elig_per_f pep,

2563: cursor c_oipl is
2564: select epo.elig_per_id,
2565: epo.elig_per_opt_id
2566: from ben_elig_per_opt_f epo,
2567: ben_elig_per_f pep,
2568: ben_oipl_f oipl
2569: where oipl.oipl_id = p_oipl_id
2570: and pep.pl_id = oipl.pl_id
2571: and pep.pgm_id = nvl(p_pgm_id, pep.pgm_id)

Line 2587: from ben_elig_per_f pep

2583: epo.effective_start_date and epo.effective_end_date;
2584: --
2585: cursor c_pl is
2586: select pep.elig_per_id
2587: from ben_elig_per_f pep
2588: where pep.pl_id = p_pl_id
2589: and pep.pgm_id = nvl(p_pgm_id, pep.pgm_id)
2590: and pep.person_id = p_person_id
2591: and pep.business_group_id = p_business_group_id