APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 140: FROM PER_ORG_STRUCTURE_ELEMENTS E

136: P_ORGANIZATION_STRUCTURE_ID IS NULL)
137: OR (P_ORGANIZATION_STRUCTURE_ID IS NOT NULL AND
138: EXISTS
139: (SELECT 1
140: FROM PER_ORG_STRUCTURE_ELEMENTS E
141: WHERE O.ORGANIZATION_ID
142: IN (E.ORGANIZATION_ID_CHILD,E.ORGANIZATION_ID_PARENT)
143: AND E.ORG_STRUCTURE_VERSION_ID = P_VERSION_ID)))
144: AND L.LOOKUP_CODE = NVL(A.MANAGER_FLAG,'N')