APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on HR_ORGANIZATION_UNITS
Line 583: hr_organization_units org
579: AND o.org_structure_version_id = p_org_structure_version_id
580: UNION
581: SELECT p_organization_id organization_id_child
582: FROM DUAL) o, 583: hr_organization_units org 584: WHERE o.organization_id_child = org.organization_id)orgs
585: WHERE asg.person_id = p_person_id AND
586: asg.organization_id = orgs.organization_id AND
587: asg.assignment_type in ('E','A','C');