DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_CBR_QUALD_BNF_F

Line 12707: from ben_elig_cbr_quald_bnf_f ecq

12703: where p_effective_date
12704: between elp.effective_start_date
12705: and elp.effective_end_date
12706: and exists(select null
12707: from ben_elig_cbr_quald_bnf_f ecq
12708: where p_effective_date
12709: between ecq.effective_start_date
12710: and ecq.effective_end_date
12711: and ecq.eligy_prfl_id = elp.eligy_prfl_id)

Line 12723: from ben_elig_cbr_quald_bnf_f ecq

12719: ecq.pgm_id, -- lamc added 2 fields
12720: ecq.ptip_id,
12721: ecq.criteria_score,
12722: ecq.criteria_weight
12723: from ben_elig_cbr_quald_bnf_f ecq
12724: where p_effective_date
12725: between ecq.effective_start_date
12726: and ecq.effective_end_date
12727: order by ecq.eligy_prfl_id;