DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_LBR_MMBR_PRTE_F

Line 7617: from ben_elig_lbr_mmbr_prte_f elu

7613: where p_effective_date
7614: between elp.effective_start_date
7615: and elp.effective_end_date
7616: and exists(select null
7617: from ben_elig_lbr_mmbr_prte_f elu
7618: where p_effective_date
7619: between elu.effective_start_date
7620: and elu.effective_end_date
7621: and elu.eligy_prfl_id = elp.eligy_prfl_id)

Line 7632: from ben_elig_lbr_mmbr_prte_f elu

7628: elu.lbr_mmbr_flag,
7629: elu.excld_flag,
7630: elu.criteria_score,
7631: elu.criteria_weight
7632: from ben_elig_lbr_mmbr_prte_f elu
7633: where p_effective_date
7634: between elu.effective_start_date
7635: and elu.effective_end_date
7636: order by elu.eligy_prfl_id,