View: POR_APPROVER_LOV_V

Product:	ICX - Oracle iProcurement
Description:	List of Values for Approvers
Implementation/DBA Data:	APPS.POR_APPROVER_LOV_V

View Text

SELECT HRE.FULL_NAME
, HRE.EMAIL_ADDRESS
, HRE.EMPLOYEE_NUM
, HRE.EMPLOYEE_ID
, HRU.NAME
, PB.NAME
FROM PER_EMPLOYEES_CURRENT_X HRE
, HR_ORGANIZATION_UNITS HRU
, PER_BUSINESS_GROUPS_PERF PB
, FND_USER FU
WHERE HRE.ORGANIZATION_ID = HRU.ORGANIZATION_ID
AND TRUNC(SYSDATE) BETWEEN HRU.DATE_FROM
AND NVL(HRU.DATE_TO
, SYSDATE+1)
AND PB.BUSINESS_GROUP_ID = HRE.BUSINESS_GROUP_ID
AND FU.EMPLOYEE_ID = HRE.EMPLOYEE_ID
AND TRUNC(SYSDATE) BETWEEN FU.START_DATE
AND NVL(FU.END_DATE
, SYSDATE+1)

Columns