DBA Data[Home] [Help]

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)