DBA Data[Home] [Help]

APPS.BEN_ELIGIBILITY_OVERRIDE dependencies on BEN_ELIG_PER_OPT_F

Line 133: from ben_elig_per_opt_f epo,

129: p_cobj_lvl in varchar2) is
130:
131: cursor c_epo is
132: select oipl.oipl_id,epo.*
133: from ben_elig_per_opt_f epo,
134: ben_elig_per_f pep,
135: ben_oipl_f oipl
136: where epo.elig_per_id = p_elig_per_rec.elig_per_id
137: and pep.elig_per_id = epo.elig_per_id

Line 357: from ben_elig_per_opt_f epo

353: and plip.business_group_id = p_business_group_id)
354: ) or
355: (p_pl_id is not null and pep.pl_id = p_pl_id and exists
356: (select null
357: from ben_elig_per_opt_f epo
358: where epo.elig_per_id = pep.elig_per_id
359: and p_effective_date between epo.effective_start_date and
360: epo.effective_end_date
361: and epo.business_group_id = p_business_group_id))