DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_LBR_MMBR_PRTE_F

Line 7813: from ben_elig_lbr_mmbr_prte_f elu

7809: where p_effective_date
7810: between elp.effective_start_date
7811: and elp.effective_end_date
7812: and exists(select null
7813: from ben_elig_lbr_mmbr_prte_f elu
7814: where p_effective_date
7815: between elu.effective_start_date
7816: and elu.effective_end_date
7817: and elu.eligy_prfl_id = elp.eligy_prfl_id)

Line 7828: from ben_elig_lbr_mmbr_prte_f elu

7824: elu.lbr_mmbr_flag,
7825: elu.excld_flag,
7826: elu.criteria_score,
7827: elu.criteria_weight
7828: from ben_elig_lbr_mmbr_prte_f elu
7829: where p_effective_date
7830: between elu.effective_start_date
7831: and elu.effective_end_date
7832: order by elu.eligy_prfl_id,