APPS.BEN_ELIG_DPNT_API dependencies on BEN_ELIG_PER_F

Line 2305: ben_elig_per_f pep,

2301: is
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

Line 2336: ben_elig_per_f pep

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
2340: and pep.pl_id = c_pl_id

Line 2359: ben_elig_per_f pep

2355: is
2356: select epo.elig_per_opt_id,
2357: epo.elig_per_id
2358: from ben_elig_per_opt_f epo,
2359: ben_elig_per_f pep
2360: where epo.per_in_ler_id = c_per_in_ler_id
2361: and c_effective_date between
2362: epo.effective_start_date and epo.effective_end_date
2363: and epo.elig_per_id = pep.elig_per_id

Line 2574: ben_elig_per_f pep,

2570: cursor c_oipl is
2571: select epo.elig_per_id,
2572: epo.elig_per_opt_id
2573: from ben_elig_per_opt_f epo,
2574: ben_elig_per_f pep,
2575: ben_oipl_f oipl
2576: where oipl.oipl_id = p_oipl_id
2577: and pep.pl_id = oipl.pl_id
2578: and pep.pgm_id = nvl(p_pgm_id, pep.pgm_id)

Line 2594: from ben_elig_per_f pep

2590: epo.effective_start_date and epo.effective_end_date;
2591: --
2592: cursor c_pl is
2593: select pep.elig_per_id
2594: from ben_elig_per_f pep
2595: where pep.pl_id = p_pl_id
2596: and pep.pgm_id = nvl(p_pgm_id, pep.pgm_id)
2597: and pep.person_id = p_person_id
2598: and pep.business_group_id = p_business_group_id