APPS.PER_ABS_BUS dependencies on DUAL

Line 510: from dual;

506:
507: cursor c_get_time_duration is
508: select ((substr(p_time_end,1,2) * 60) + substr(p_time_end,4,2)) -
509: ((substr(p_time_start,1,2) * 60) + substr(p_time_start,4,2))
510: from dual;
511: --
512:
513: begin
514:

Line 813: FROM DUAL;

809: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
810: SELECT p_duration + (((SUBSTR(l_day_end_time,1,2)*60 + SUBSTR(l_day_end_time,4,2)) -
811: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
812: INTO p_duration
813: FROM DUAL;
814: --
815: -- Get last day hours
816: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
817: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -

Line 820: FROM DUAL;

816: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
817: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
818: (SUBSTR(l_day_start_time,1,2)*60 + SUBSTR(l_day_start_time,4,2)) + 1)/60)
819: INTO p_duration
820: FROM DUAL;
821: --
822: -- Get between full day hours
823: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
824: INTO p_duration

Line 825: FROM DUAL;

821: --
822: -- Get between full day hours
823: SELECT p_duration + ((TRUNC(l_schedule(l_idx).END_DATE_TIME) - TRUNC(l_schedule(l_idx).START_DATE_TIME) - 1) * 24)
824: INTO p_duration
825: FROM DUAL;
826: ELSE
827: -- Start and End on same day
828: l_start_time := TO_CHAR(l_schedule(l_idx).START_DATE_TIME,'HH24:MI');
829: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');

Line 833: FROM DUAL;

829: l_end_time := TO_CHAR(l_schedule(l_idx).END_DATE_TIME,'HH24:MI');
830: SELECT p_duration + (((SUBSTR(l_end_time,1,2)*60 + SUBSTR(l_end_time,4,2)) -
831: (SUBSTR(l_start_time,1,2)*60 + SUBSTR(l_start_time,4,2)))/60)
832: INTO p_duration
833: FROM DUAL;
834: END IF;
835: END IF;
836: END IF;
837: END IF;

Line 1252: into l_invalid_message_num from dual;

1248: -- Displays the error message text if the error message
1249: -- name is given
1250: -- This is done as SSHR supports both text as well as name
1251: select instr(l_invalid_message,' ',1,1)
1252: into l_invalid_message_num from dual;
1253:
1254: if l_invalid_message_num = 0
1255: then
1256: l_invalid_message_txt := fnd_message.get_string('PER',l_invalid_message);