DBA Data[Home] [Help]

APPS.HR_RU_UTILITY dependencies on HR_ORGANIZATION_UNITS

Line 467: FROM hr_organization_units hou, hr_organization_information hoi

463: SELECT 'Y'
464: FROM SYS.dual
465: WHERE EXISTS (
466: SELECT '1'
467: FROM hr_organization_units hou, hr_organization_information hoi
468: WHERE (p_org_id <> hoi.organization_id)
469: AND hou.organization_id = hoi.organization_id
470: AND hou.business_group_id IN (
471: SELECT o3.organization_id