DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_ORG_UNIT_PRTE_F

Line 4366: from ben_elig_org_unit_prte_f eou

4362: where p_effective_date
4363: between elp.effective_start_date
4364: and elp.effective_end_date
4365: and exists(select null
4366: from ben_elig_org_unit_prte_f eou
4367: where p_effective_date
4368: between eou.effective_start_date
4369: and eou.effective_end_date
4370: and eou.eligy_prfl_id = elp.eligy_prfl_id)

Line 4381: from ben_elig_org_unit_prte_f eou

4377: eou.organization_id,
4378: eou.excld_flag,
4379: eou.criteria_score,
4380: eou.criteria_weight
4381: from ben_elig_org_unit_prte_f eou
4382: where p_effective_date
4383: between eou.effective_start_date
4384: and eou.effective_end_date
4385: order by eou.eligy_prfl_id,