SELECT 'DEFAULT' ORGANIZATION_ID,'All Operating Units' Name FROM dual UNION SELECT To_Char(HrOperatingUnits.ORGANIZATION_ID) ORGANIZATION_ID, HrOperatingUnits.NAME FROM HR_OPERATING_UNITS HrOperatingUnits WHERE TRUNC(SYSDATE) BETWEEN NVL(HrOperatingUnits.DATE_FROM, TRUNC(SYSDATE)) AND NVL(HrOperatingUnits.DATE_TO, TRUNC(SYSDATE))
SELECT 'DEFAULT' ORGANIZATION_ID
, 'ALL OPERATING UNITS' NAME
FROM DUAL UNION SELECT TO_CHAR(HROPERATINGUNITS.ORGANIZATION_ID) ORGANIZATION_ID
, HROPERATINGUNITS.NAME
FROM HR_OPERATING_UNITS HROPERATINGUNITS
WHERE TRUNC(SYSDATE) BETWEEN NVL(HROPERATINGUNITS.DATE_FROM
, TRUNC(SYSDATE))
AND NVL(HROPERATINGUNITS.DATE_TO
, TRUNC(SYSDATE))
|
|
|