[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
| Name |
| START_DATE |
| START_TIME |
| END_DATE |
| END_TIME |
| AVAILABILITY |
| SCHEDULE_LEVEL |