APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_ELIG_PER_F

Line 41: FROM ben_elig_per_opt_f epo, ben_per_in_ler pil, ben_elig_per_f pep

37: c_pgm_id IN NUMBER
38: )
39: IS
40: SELECT epo.elig_flag
41: FROM ben_elig_per_opt_f epo, ben_per_in_ler pil, ben_elig_per_f pep
42: WHERE pep.person_id = c_person_id
43: AND pep.pl_id = c_pl_id
44: AND epo.opt_id = c_opt_id
45: AND pep.elig_per_id = epo.elig_per_id

Line 69: FROM ben_elig_per_f pep, ben_per_in_ler pil

65: c_effective_date IN DATE
66: )
67: IS
68: SELECT pep.elig_flag
69: FROM ben_elig_per_f pep, ben_per_in_ler pil
70: WHERE pep.person_id = c_person_id
71: AND NVL (pep.pgm_id, -1) = NVL (c_pgm_id, -1)
72: -- bug 5947036/ bug 6379215
73: AND pep.pl_id = c_pl_id