DBA Data[Home] [Help]

APPS.OTA_MANDATORY_ENROLL_UTIL dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 575: FROM per_org_structure_elements o

571: FROM per_all_assignments_f asg,
572: (
573: SELECT o.organization_id_child as organization_id
574: FROM (SELECT o.organization_id_child
575: FROM per_org_structure_elements o
576: CONNECT BY o.organization_id_parent = PRIOR o.organization_id_child
577: AND o.org_structure_version_id = PRIOR o.org_structure_version_id
578: START WITH o.organization_id_parent = p_organization_id
579: AND o.org_structure_version_id = p_org_structure_version_id