DBA Data[Home] [Help]

APPS.BEN_ELIG_DPNT_API dependencies on BEN_OIPL_F

Line 2307: ben_oipl_f oipl

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
2311: and c_effective_date between

Line 2575: ben_oipl_f oipl

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)
2579: and pep.person_id = p_person_id