[Home] [Help]
View: HR_SCHEDULER_V
Product: | PER - Human Resources |
Description: | Used to support user interface |
Implementation/DBA Data: |
APPS.HR_SCHEDULER_V
|
View Text
SELECT HR_CALENDAR_PKG.START_DATE (ROWNUM)
, TO_CHAR (HR_CALENDAR_PKG.START_DATE (ROWNUM)
, 'HH24:MI')
, HR_CALENDAR_PKG.END_DATE (ROWNUM)
, TO_CHAR (HR_CALENDAR_PKG.END_DATE (ROWNUM)
, 'HH24:MI')
, SUBSTR (HR_CALENDAR_PKG.AVAILABILITY_VALUE (ROWNUM)
, 1
, 80)
, HR_CALENDAR_PKG.SCHEDULE_LEVEL_VALUE (ROWNUM)
FROM FND_COMMON_LOOKUPS
, /* -- NB THE CARTESIAN JOIN IS DELIBERATE!!!!! */ FND_COMMON_LOOKUPS
WHERE ROWNUM <= HR_CALENDAR_PKG.SCHEDULE_ROWCOUNT
Columns
START_DATE |
START_TIME |
END_DATE |
END_TIME |
AVAILABILITY |
SCHEDULE_LEVEL |
Name |