eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FI_GENERAL dependencies on DUAL

Line 1627: SELECT replace(trim(to_char(to_number(l_time),'00.00')),'.',':') FROM dual;

1623: l_time_end VARCHAR2(10); --5 to 10
1624: --
1625: e_bad_time_format EXCEPTION;
1626: CURSOR get_time_format(l_time varchar2) is
1627: SELECT replace(trim(to_char(to_number(l_time),'00.00')),'.',':') FROM dual;
1628: --
1629: BEGIN
1630: hr_utility.set_location('Entering '||'.calc_sch_based_dur',10);
1631: l_return := 0;

Line 1753: FROM DUAL;

1749: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
1750: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
1751: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
1752: INTO p_duration
1753: FROM DUAL;
1754: --
1755: -- Get last day hours
1756: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
1757: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -

Line 1760: FROM DUAL;

1756: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
1757: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
1758: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
1759: INTO p_duration
1760: FROM DUAL;
1761: --
1762: -- Get between full day hours
1763: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
1764: INTO p_duration

Line 1765: FROM DUAL;

1761: --
1762: -- Get between full day hours
1763: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
1764: INTO p_duration
1765: FROM DUAL;
1766: ELSE
1767: -- Start and End on same day
1768: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
1769: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');

Line 1773: FROM DUAL;

1769: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
1770: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
1771: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
1772: INTO p_duration
1773: FROM DUAL;
1774: END IF;
1775: END IF;
1776: END IF;
1777: END IF;