DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 8872: hr_all_organization_units hao

8868: between elp.effective_start_date
8869: and elp.effective_end_date
8870: and exists(select null
8871: from ben_elig_lgl_enty_prte_f eln,
8872: hr_all_organization_units hao
8873: where eln.organization_id = hao.organization_id
8874: and eln.business_group_id = hao.business_group_id
8875: and p_effective_date
8876: between eln.effective_start_date

Line 8890: hr_all_organization_units hao

8886: eln.criteria_score,
8887: eln.criteria_weight,
8888: hao.name
8889: from ben_elig_lgl_enty_prte_f eln,
8890: hr_all_organization_units hao
8891: where eln.organization_id = hao.organization_id
8892: and eln.business_group_id = hao.business_group_id
8893: and p_effective_date
8894: between eln.effective_start_date