DBA Data[Home] [Help]

APPS.BEN_ELP_CACHE dependencies on HR_ALL_ORGANIZATION_UNITS

Line 9113: hr_all_organization_units hao

9109: between elp.effective_start_date
9110: and elp.effective_end_date
9111: and exists(select null
9112: from ben_elig_lgl_enty_prte_f eln,
9113: hr_all_organization_units hao
9114: where eln.organization_id = hao.organization_id
9115: and eln.business_group_id = hao.business_group_id
9116: and p_effective_date
9117: between eln.effective_start_date

Line 9131: hr_all_organization_units hao

9127: eln.criteria_score,
9128: eln.criteria_weight,
9129: hao.name
9130: from ben_elig_lgl_enty_prte_f eln,
9131: hr_all_organization_units hao
9132: where eln.organization_id = hao.organization_id
9133: and eln.business_group_id = hao.business_group_id
9134: and p_effective_date
9135: between eln.effective_start_date