DBA Data[Home] [Help]

APPS.INV_COPY_ORGANIZATION_REPORT dependencies on PER_ORG_STRUCTURE_VERSIONS

Line 1074: , PER_ORG_STRUCTURE_VERSIONS ver

1070: )
1071: IS
1072: SELECT DISTINCT hier.NAME
1073: FROM PER_ORG_STRUCTURE_ELEMENTS mdl
1074: , PER_ORG_STRUCTURE_VERSIONS ver
1075: , PER_ORGANIZATION_STRUCTURES hier
1076: WHERE ORGANIZATION_ID_CHILD = p_model_org_id
1077: AND ver.ORG_STRUCTURE_VERSION_ID = mdl.ORG_STRUCTURE_VERSION_ID
1078: AND hier.ORGANIZATION_STRUCTURE_ID = ver.ORGANIZATION_STRUCTURE_ID