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;