DBA Data[Home] [Help]

APPS.PAY_SE_HOLIDAY_PAY dependencies on DUAL

Line 3412: FROM DUAL;

3408:
3409: CURSOR get_total_days (csr_end_date DATE, csr_start_date DATE)
3410: IS
3411: SELECT FLOOR (csr_end_date - csr_start_date) + 1
3412: FROM DUAL;
3413:
3414: CURSOR get_time_format (l_time VARCHAR2)
3415: IS
3416: SELECT REPLACE (TRIM (l_time), ':', '.')

Line 3417: FROM DUAL;

3413:
3414: CURSOR get_time_format (l_time VARCHAR2)
3415: IS
3416: SELECT REPLACE (TRIM (l_time), ':', '.')
3417: FROM DUAL;
3418:
3419: l_start_time VARCHAR2 (5);
3420: l_end_time VARCHAR2 (5);
3421: BEGIN