DBA Data[Home] [Help]

APPS.PQH_FR_UTILITY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2110: FROM hr_all_organization_units hru

2106: ,p_effective_date IN DATE) RETURN VARCHAR2
2107: IS
2108: CURSOR c_owner_cur IS
2109: SELECT hru.name
2110: FROM hr_all_organization_units hru
2111: ,hr_organization_information hri
2112: WHERE hru.organization_id = p_org_id
2113: AND hru.organization_id = hri.organization_id
2114: AND hri.org_information_context = 'CLASS'