DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_CBR_QUALD_BNF_F

Line 13092: from ben_elig_cbr_quald_bnf_f ecq

13088: where p_effective_date
13089: between elp.effective_start_date
13090: and elp.effective_end_date
13091: and exists(select null
13092: from ben_elig_cbr_quald_bnf_f ecq
13093: where p_effective_date
13094: between ecq.effective_start_date
13095: and ecq.effective_end_date
13096: and ecq.eligy_prfl_id = elp.eligy_prfl_id)

Line 13108: from ben_elig_cbr_quald_bnf_f ecq

13104: ecq.pgm_id, -- lamc added 2 fields
13105: ecq.ptip_id,
13106: ecq.criteria_score,
13107: ecq.criteria_weight
13108: from ben_elig_cbr_quald_bnf_f ecq
13109: where p_effective_date
13110: between ecq.effective_start_date
13111: and ecq.effective_end_date
13112: order by ecq.eligy_prfl_id;