APPS.BEN_REOPEN_ENDED_RESULTS dependencies on BEN_PER_IN_LER

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

Line 226: ben_per_in_ler pil

222: p_business_group_id in number) is
223:
224: select pen.*
225: from ben_prtt_enrt_rslt_f pen,
226: ben_per_in_ler pil
227: where pen.person_id = p_person_id
228: and pen.effective_end_date = hr_api.g_eot
229: and pen.business_group_id = p_business_group_id
230: and pil.business_group_id = p_business_group_id

Line 248: ben_per_in_ler pil

244: p_business_group_id in number) is
245:
246: select pen.*
247: from ben_prtt_enrt_rslt_f pen,
248: ben_per_in_ler pil
249: where pen.person_id = p_person_id
250: and pen.effective_end_date = hr_api.g_eot
251: and pen.business_group_id = p_business_group_id
252: and pil.business_group_id = p_business_group_id

Line 360: from ben_per_in_ler pil

356: and epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
357: --
358: cursor c_get_prior_per_in_ler is
359: select 'Y'
360: from ben_per_in_ler pil
361: where pil.per_in_ler_id <> p_per_in_ler_id
362: and trunc(p_lf_evt_ocrd_dt, 'MM') = trunc(pil.lf_evt_ocrd_dt, 'MM')
363: and pil.person_id = p_person_id
364: and pil.business_group_id = p_business_group_id