VIEW: APPS.PA_MANAGERS_V

Source

View Text - Preformatted

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 , per.email_address , flv.meaning from per_assignments_f assign , per_assignment_status_types ast , per_people_x per , per_assignments_f assign2 , hr_organization_units hrorg , fnd_lookup_values flv 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 AND flv.view_application_id=3 AND flv.lookup_type = 'PERSON_TYPE' AND flv.language = USERENV('LANG') AND flv.lookup_code=decode(per.current_employee_flag,'Y','EMP','CWK')

View Text - HTML Formatted

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
, PER.EMAIL_ADDRESS
, FLV.MEANING
FROM PER_ASSIGNMENTS_F ASSIGN
, PER_ASSIGNMENT_STATUS_TYPES AST
, PER_PEOPLE_X PER
, PER_ASSIGNMENTS_F ASSIGN2
, HR_ORGANIZATION_UNITS HRORG
, FND_LOOKUP_VALUES FLV
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
AND FLV.VIEW_APPLICATION_ID=3
AND FLV.LOOKUP_TYPE = 'PERSON_TYPE'
AND FLV.LANGUAGE = USERENV('LANG')
AND FLV.LOOKUP_CODE=DECODE(PER.CURRENT_EMPLOYEE_FLAG
, 'Y'
, 'EMP'
, 'CWK')