DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_JOB_PRTE_F

Line 6640: from ben_elig_job_prte_f ejp

6636: where p_effective_date
6637: between elp.effective_start_date
6638: and elp.effective_end_date
6639: and exists(select null
6640: from ben_elig_job_prte_f ejp
6641: where p_effective_date
6642: between ejp.effective_start_date
6643: and ejp.effective_end_date
6644: and ejp.eligy_prfl_id = elp.eligy_prfl_id)

Line 6655: from ben_elig_job_prte_f ejp

6651: ejp.job_id,
6652: ejp.excld_flag,
6653: ejp.criteria_score,
6654: ejp.criteria_weight
6655: from ben_elig_job_prte_f ejp
6656: where p_effective_date
6657: between ejp.effective_start_date
6658: and ejp.effective_end_date
6659: order by ejp.eligy_prfl_id,