DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_JOB_PRTE_F

Line 6800: from ben_elig_job_prte_f ejp

6796: where p_effective_date
6797: between elp.effective_start_date
6798: and elp.effective_end_date
6799: and exists(select null
6800: from ben_elig_job_prte_f ejp
6801: where p_effective_date
6802: between ejp.effective_start_date
6803: and ejp.effective_end_date
6804: and ejp.eligy_prfl_id = elp.eligy_prfl_id)

Line 6815: from ben_elig_job_prte_f ejp

6811: ejp.job_id,
6812: ejp.excld_flag,
6813: ejp.criteria_score,
6814: ejp.criteria_weight
6815: from ben_elig_job_prte_f ejp
6816: where p_effective_date
6817: between ejp.effective_start_date
6818: and ejp.effective_end_date
6819: order by ejp.eligy_prfl_id,