VIEW: APPS.AS_PERSONS_ACTIVE_V

Source

View Text - Preformatted

SELECT p.person_id ,p.first_name ,p.last_name ,p.first_name || ' ' || p.last_name ,j.name ,look.meaning ,p.work_telephone ,p.email_address ,p.employee_number FROM PER_ALL_PEOPLE_F p , PER_ALL_ASSIGNMENTS_F a , PER_JOBS j , HR_LOOKUPS look WHERE p.person_id = a.person_id AND a.primary_flag = 'Y' AND a.assignment_type = 'E' AND p.employee_number is not null AND j.job_id(+) = a.job_id AND trunc(sysdate) between p.effective_start_date and p.effective_end_date AND ((trunc(sysdate) between a.effective_start_date and a.effective_end_date)) AND p.title = look.lookup_code(+) AND look.lookup_type(+) = 'TITLE'

View Text - HTML Formatted

SELECT P.PERSON_ID
, P.FIRST_NAME
, P.LAST_NAME
, P.FIRST_NAME || ' ' || P.LAST_NAME
, J.NAME
, LOOK.MEANING
, P.WORK_TELEPHONE
, P.EMAIL_ADDRESS
, P.EMPLOYEE_NUMBER
FROM PER_ALL_PEOPLE_F P
, PER_ALL_ASSIGNMENTS_F A
, PER_JOBS J
, HR_LOOKUPS LOOK
WHERE P.PERSON_ID = A.PERSON_ID
AND A.PRIMARY_FLAG = 'Y'
AND A.ASSIGNMENT_TYPE = 'E'
AND P.EMPLOYEE_NUMBER IS NOT NULL
AND J.JOB_ID(+) = A.JOB_ID
AND TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE
AND ((TRUNC(SYSDATE) BETWEEN A.EFFECTIVE_START_DATE
AND A.EFFECTIVE_END_DATE))
AND P.TITLE = LOOK.LOOKUP_CODE(+)
AND LOOK.LOOKUP_TYPE(+) = 'TITLE'