DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY4 dependencies on BEN_ELIG_PER_F

Line 43: from ben_elig_per_f pep,

39: pep.per_in_ler_id,
40: pep.object_version_number,
41: pep.age_val,
42: pep.los_val
43: from ben_elig_per_f pep,
44: ben_per_in_ler pil
45: where pep.person_id = c_person_id
46: and nvl(pep.pgm_id,-1) = c_pgm_id
47: and nvl(pep.pl_id,-1) = c_pl_id

Line 161: ben_elig_per_f pep

157: epo.age_val,
158: epo.los_val
159: from ben_elig_per_opt_f epo,
160: ben_per_in_ler pil,
161: ben_elig_per_f pep
162: where pep.person_id = c_person_id
163: and pep.pl_id = c_pl_id
164: and epo.opt_id = c_opt_id
165: and pep.elig_per_id = epo.elig_per_id