DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_PRTT_ANTHR_PL_PRTE_F

Line 9122: from ben_elig_prtt_anthr_pl_prte_f epp

9118: where p_effective_date
9119: between elp.effective_start_date
9120: and elp.effective_end_date
9121: and exists(select null
9122: from ben_elig_prtt_anthr_pl_prte_f epp
9123: where p_effective_date
9124: between epp.effective_start_date
9125: and epp.effective_end_date
9126: and epp.eligy_prfl_id = elp.eligy_prfl_id)

Line 9133: from ben_elig_prtt_anthr_pl_prte_f epp

9129: cursor c_elpepp_inst is
9130: select epp.eligy_prfl_id,
9131: epp.pl_id,
9132: epp.excld_flag
9133: from ben_elig_prtt_anthr_pl_prte_f epp
9134: where p_effective_date
9135: between epp.effective_start_date
9136: and epp.effective_end_date
9137: order by epp.eligy_prfl_id,