VIEW: APPS.HR_FNDSCAUS_PERSON_LOV_V

Source

View Text - Preformatted

SELECT p.full_name , decode(p.current_employee_flag,'Y','*','y','*','') current_employee_flag , decode(p.current_npw_flag,'Y','*','y','*','') current_npw_flag , otl.name , p.employee_number , p.npw_number , p.email_address , p.person_id FROM per_all_people_f p , hr_all_organization_units_tl otl WHERE p.business_group_id = otl.organization_id and otl.language = userenv('LANG') and ( trunc(sysdate) between p.effective_start_date and p.effective_end_date or ( p.effective_start_date = ( select min(p2.effective_start_date) from per_all_people_f p2 where p2.person_id = p.person_id ) and p.effective_start_date > trunc(sysdate) ) )

View Text - HTML Formatted

SELECT P.FULL_NAME
, DECODE(P.CURRENT_EMPLOYEE_FLAG
, 'Y'
, '*'
, 'Y'
, '*'
, '') CURRENT_EMPLOYEE_FLAG
, DECODE(P.CURRENT_NPW_FLAG
, 'Y'
, '*'
, 'Y'
, '*'
, '') CURRENT_NPW_FLAG
, OTL.NAME
, P.EMPLOYEE_NUMBER
, P.NPW_NUMBER
, P.EMAIL_ADDRESS
, P.PERSON_ID
FROM PER_ALL_PEOPLE_F P
, HR_ALL_ORGANIZATION_UNITS_TL OTL
WHERE P.BUSINESS_GROUP_ID = OTL.ORGANIZATION_ID
AND OTL.LANGUAGE = USERENV('LANG')
AND ( TRUNC(SYSDATE) BETWEEN P.EFFECTIVE_START_DATE
AND P.EFFECTIVE_END_DATE OR ( P.EFFECTIVE_START_DATE = ( SELECT MIN(P2.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F P2
WHERE P2.PERSON_ID = P.PERSON_ID )
AND P.EFFECTIVE_START_DATE > TRUNC(SYSDATE) ) )