APPS.PER_ORG_MAN_COUNT_NAME_PKG dependencies on PER_ASSIGNMENT_STATUS_TYPES
Line 126: AND (SELECT PER_SYSTEM_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES PAST
122: FND_LOOKUPS L
123: WHERE A.PERSON_ID = P_PERSON_ID
124: AND (A.ASSIGNMENT_TYPE = 'E' OR A.ASSIGNMENT_TYPE = 'C')
125: --Added for Bug 6010637 126: AND (SELECT PER_SYSTEM_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES PAST 127: WHERE A.ASSIGNMENT_STATUS_TYPE_ID = PAST.ASSIGNMENT_STATUS_TYPE_ID
128: AND A.ASSIGNMENT_TYPE IN ('E','C')) IN ('ACTIVE_ASSIGN','ACTIVE_CWK')
129: --
130: AND P_SESSION_DATE BETWEEN