416: and FND_USER.EMPLOYEE_ID is NULL
417: and trunc(sysdate) between trunc(start_date) and nvl(end_date,sysdate)
418: union all
419: select 'T'
420: from FND_USER USR, PER_PEOPLE_F PER
421: where USR.USER_NAME=p_account
422: and trunc(sysdate) between trunc(USR.start_date) and nvl(USR.end_date,sysdate)
423: and USR.EMPLOYEE_ID = PER.PERSON_ID
424: and trunc(sysdate) between trunc(per.effective_start_date) and nvl(per.effective_end_date,sysdate)
948: select
949: USR.USER_NAME name,
950: PER.FULL_NAME display_name
951: from
952: PER_PEOPLE_F PER,
953: FND_USER USR
954: where trunc(SYSDATE) between PER.EFFECTIVE_START_DATE
955: and PER.EFFECTIVE_END_DATE
956: and PER.PERSON_ID = USR.EMPLOYEE_ID
968: union all
969: select
970: USR.USER_NAME name, PER.FULL_NAME display_name
971: from
972: PER_PEOPLE_F PER,
973: FND_USER USR
974: where trunc(SYSDATE)
975: between PER.EFFECTIVE_START_DATE and PER.EFFECTIVE_END_DATE
976: and PER.PERSON_ID = USR.EMPLOYEE_ID