APPS.PA_ROLE_PROFILES_UTILS dependencies on HR_ORGANIZATION_UNITS
Line 295: FROM HR_ORGANIZATION_UNITS
291: IF x_organization_id IS NOT NULL THEN
292: BEGIN
293: SELECT 'Y'
294: INTO l_exists 295: FROM HR_ORGANIZATION_UNITS 296: WHERE organization_id = x_organization_id
297: AND business_group_id = NVL(x_business_group_id, business_group_id);
298:
299: EXCEPTION