View: PA_MANAGERS_V

Product:	PA - Projects
Description:	PA_MANAGERS_V is a view that shows manager details for all primary active assignments.
Implementation/DBA Data:	APPS.PA_MANAGERS_V

View Text

SELECT PER.FIRST_NAME
, PER.LAST_NAME
, PER.FULL_NAME
, ASSIGN.SUPERVISOR_ID
, HRORG.NAME
, ASSIGN2.ORGANIZATION_ID
, ASSIGN2.EFFECTIVE_START_DATE
, ASSIGN2.EFFECTIVE_END_DATE
FROM PER_ASSIGNMENTS_F ASSIGN
, PER_ASSIGNMENT_STATUS_TYPES AST
, PER_PEOPLE_X PER
, PER_ASSIGNMENTS_F ASSIGN2
, HR_ORGANIZATION_UNITS HRORG
WHERE ASSIGN.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
AND AST.PER_SYSTEM_STATUS IN ('ACTIVE_ASSIGN'
, 'ACTIVE_CWK')
AND ASSIGN.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND ASSIGN.JOB_ID IS NOT NULL
AND ASSIGN.PRIMARY_FLAG = 'Y'
AND NVL(ASSIGN.EFFECTIVE_END_DATE
, SYSDATE) >= TRUNC(SYSDATE)
AND ASSIGN.SUPERVISOR_ID = PER.PERSON_ID
AND ASSIGN.SUPERVISOR_ID = ASSIGN2.PERSON_ID
AND ASSIGN2.ASSIGNMENT_STATUS_TYPE_ID = AST.ASSIGNMENT_STATUS_TYPE_ID
AND ASSIGN2.ASSIGNMENT_TYPE IN ('E'
, 'C')
AND ASSIGN2.JOB_ID IS NOT NULL
AND ASSIGN2.PRIMARY_FLAG = 'Y'
AND NVL(ASSIGN2.EFFECTIVE_END_DATE
, SYSDATE) >= TRUNC(SYSDATE)
AND ASSIGN2.ORGANIZATION_ID = HRORG.ORGANIZATION_ID

Columns