SELECT DISTINCT(HRE.FULL_NAME) , HRE.EMPLOYEE_NUM , HRE.LOCATION_ID , PAA.SCHEDULER_ID FROM PO_ASL_ATTRIBUTES_VAL_V PAA, HR_EMPLOYEES_CURRENT_V HRE WHERE PAA.SCHEDULER_ID = HRE.EMPLOYEE_ID AND SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1)
SELECT DISTINCT(HRE.FULL_NAME)
, HRE.EMPLOYEE_NUM
, HRE.LOCATION_ID
, PAA.SCHEDULER_ID
FROM PO_ASL_ATTRIBUTES_VAL_V PAA
, HR_EMPLOYEES_CURRENT_V HRE
WHERE PAA.SCHEDULER_ID = HRE.EMPLOYEE_ID
AND SYSDATE < NVL(INACTIVE_DATE
, SYSDATE + 1)
|
|
|