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 = null
44: and c_effective_date
45: between epo.effective_start_date

Line 64: ben_elig_per_f epo

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

Line 112: ben_elig_per_f epo,

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

Line 167: from ben_elig_per_f epo,

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

Line 388: ben_elig_per_f epo,

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