VIEW: APPS.HRI_CL_PER_HIRMGR_HX_V

Source

View Text - Preformatted

SELECT /*+ INDEX(peo per_people_f_pk) */ peo.person_id ID ,peo.full_name VALUE ,peo.effective_start_date START_DATE ,peo.effective_end_date END_DATE ,peo.party_id PARTY_ID FROM per_people_f peo, per_all_vacancies vac WHERE TRUNC(sysdate) BETWEEN peo.effective_start_date AND peo.effective_end_date AND vac.manager_id = peo.person_id AND ( peo.current_employee_flag = 'Y' OR peo.current_npw_flag = 'Y' ) AND vac.vacancy_id = (SELECT MAX(vac2.vacancy_id) FROM per_all_vacancies vac2 WHERE vac.manager_id = vac2.manager_id) UNION ALL SELECT -1 ID , '' VALUE , hr_general.start_of_time DATE_FROM , hr_general.end_of_time DATE_TO , -1 BUSINESS_GROUP_ID FROM dual

View Text - HTML Formatted

SELECT /*+ INDEX(PEO PER_PEOPLE_F_PK) */ PEO.PERSON_ID ID
, PEO.FULL_NAME VALUE
, PEO.EFFECTIVE_START_DATE START_DATE
, PEO.EFFECTIVE_END_DATE END_DATE
, PEO.PARTY_ID PARTY_ID
FROM PER_PEOPLE_F PEO
, PER_ALL_VACANCIES VAC
WHERE TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND VAC.MANAGER_ID = PEO.PERSON_ID
AND ( PEO.CURRENT_EMPLOYEE_FLAG = 'Y' OR PEO.CURRENT_NPW_FLAG = 'Y' )
AND VAC.VACANCY_ID = (SELECT MAX(VAC2.VACANCY_ID)
FROM PER_ALL_VACANCIES VAC2
WHERE VAC.MANAGER_ID = VAC2.MANAGER_ID) UNION ALL SELECT -1 ID
, '' VALUE
, HR_GENERAL.START_OF_TIME DATE_FROM
, HR_GENERAL.END_OF_TIME DATE_TO
, -1 BUSINESS_GROUP_ID
FROM DUAL