DBA Data[Home] [Help]

APPS.HR_ORG_INFORMATION_PKG dependencies on HR_ORGANIZATION_UNITS

Line 192: FROM hr_organization_units org

188: (p_organization_id IN NUMBER
189: )
190: IS
191: SELECT 0
192: FROM hr_organization_units org
193: ,per_business_groups bgp
194: WHERE bgp.name = org.name
195: AND bgp.organization_id <> org.organization_id
196: AND org.organization_id = p_organization_id;