DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_FL_TM_PT_TM_PRTE_F

Line 4956: from ben_elig_fl_tm_pt_tm_prte_f efp

4952: where p_effective_date
4953: between elp.effective_start_date
4954: and elp.effective_end_date
4955: and exists(select null
4956: from ben_elig_fl_tm_pt_tm_prte_f efp
4957: where p_effective_date
4958: between efp.effective_start_date
4959: and efp.effective_end_date
4960: and efp.eligy_prfl_id = elp.eligy_prfl_id)

Line 4971: from ben_elig_fl_tm_pt_tm_prte_f efp

4967: efp.fl_tm_pt_tm_cd,
4968: efp.excld_flag,
4969: efp.criteria_score,
4970: efp.criteria_weight
4971: from ben_elig_fl_tm_pt_tm_prte_f efp
4972: where p_effective_date
4973: between efp.effective_start_date
4974: and efp.effective_end_date
4975: order by efp.eligy_prfl_id,