APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS
Line 133: FROM PER_ORG_STRUCTURE_ELEMENTS E
129: P_ORGANIZATION_STRUCTURE_ID IS NULL)
130: OR (P_ORGANIZATION_STRUCTURE_ID IS NOT NULL AND
131: EXISTS
132: (SELECT 1 133: FROM PER_ORG_STRUCTURE_ELEMENTS E 134: WHERE O.ORGANIZATION_ID
135: IN (E.ORGANIZATION_ID_CHILD,E.ORGANIZATION_ID_PARENT)
136: AND E.ORG_STRUCTURE_VERSION_ID = P_VERSION_ID)))
137: AND L.LOOKUP_CODE = NVL(A.MANAGER_FLAG,'N')