APPS.BEN_ELPRO_CHECK_ELIGIBILITY dependencies on BEN_ELIG_PER_F

Line 41: from ben_elig_per_f epo

37: )
38: is
39: select /*+ bendtlep.check_elig_othr_ptip_prte.pilc1 */
40: null
41: from ben_elig_per_f epo
42: where epo.ptip_id = c_ptip_id
43: and epo.pl_id is null
44: and epo.per_in_ler_id = c_per_in_ler_id
45: and epo.elig_flag = 'Y';

Line 62: ben_elig_per_f epo

58: ben_plip_f cpp,
59: ben_ptip_f ctp,
60: ben_pl_regn_f prg,
61: ben_regn_f reg,
62: ben_elig_per_f epo
63: where pln.pl_id = cpp.pl_id
64: and c_effective_date
65: between pln.effective_start_date
66: and pln.effective_end_date

Line 110: ben_elig_per_f epo,

106: ben_plip_f cpp,
107: ben_ptip_f ctp,
108: ben_pl_regn_f prg,
109: ben_regn_f reg,
110: ben_elig_per_f epo,
111: ben_per_in_ler pil
112: where pln.pl_id = cpp.pl_id
113: and pln.business_group_id = c_business_group_id
114: and c_effective_date

Line 165: from ben_elig_per_f epo,

161: )
162: is
163: select /*+ bendtlep.check_elig_othr_ptip_prte.c1 */
164: null
165: from ben_elig_per_f epo,
166: ben_per_in_ler pil
167: where epo.person_id = c_person_id
168: and epo.pl_id is null
169: and epo.ptip_id = c_ptip_id

Line 386: ben_elig_per_f epo,

382: null
383: from ben_pl_f pln,
384: ben_plip_f cpp,
385: ben_ptip_f ctp,
386: ben_elig_per_f epo,
387: ben_elig_dpnt edp,
388: ben_per_in_ler pil
389: --per_contact_relationships pcr -- bug 6811004 fix reverted for bug 9900419
390: where pln.pl_id = cpp.pl_id