APPS.AMW_SCOPE_PVT dependencies on PER_ORG_STRUCTURE_VERSIONS
Line 695: FROM per_org_structure_versions
691: CURSOR find_parent(l_organization_id NUMBER, hiername VARCHAR2) IS
692: SELECT organization_id_parent
693: FROM per_org_structure_elements
694: WHERE org_structure_version_id =(SELECT org_structure_version_id 695: FROM per_org_structure_versions 696: WHERE organization_structure_id =(SELECT organization_structure_id
697: FROM per_organization_structures
698: WHERE name = hiername)
699: and date_to is null)