APPS.PER_ABS_BUS dependencies on DUAL

Line 511: from dual;

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

Line 814: FROM DUAL;

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

Line 821: FROM DUAL;

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

Line 826: FROM DUAL;

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

Line 834: FROM DUAL;

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

Line 1439: into l_invalid_message_num from dual;

1435: -- Displays the error message text if the error message
1436: -- name is given
1437: -- This is done as SSHR supports both text as well as name
1438: select instr(l_invalid_message,' ',1,1)
1439: into l_invalid_message_num from dual;
1440:
1441: if l_invalid_message_num = 0
1442: then
1443: l_invalid_message_txt := fnd_message.get_string('PER',l_invalid_message);