APPS.GMP_CALENDAR_API dependencies on DUAL

Line 69: SELECT 1 FROM dual

65: l_api_name CONSTANT VARCHAR2(30) := 'IS_WORKING_DAY';
66: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
67:
68: CURSOR get_day_cur (c_calendar_id VARCHAR2 , c_cal_date DATE) IS
69: SELECT 1 FROM dual
70: WHERE EXISTS
71: (SELECT 1
72: FROM BOM_shift_dates sd, bom_shift_times sht
73: WHERE sd.calendar_code = sht.calendar_code

Line 404: INTO l_start_time FROM DUAL;

400: IF p_start_date is NOT NULL THEN
401: /* { */
402: l_start_time := 0 ;
403: SELECT ( p_start_date - TRUNC(p_start_date) ) * 86400
404: INTO l_start_time FROM DUAL;
405:
406: x_return_status := 'S';
407: FOR cur_rec in start_date_cur (p_calendar_code, p_start_date)
408: LOOP

Line 512: INTO l_end_time FROM DUAL;

508: ELSIF p_end_date is NOT NULL THEN
509:
510: l_end_time := 0 ;
511: SELECT ( p_end_date - TRUNC(p_end_date) ) * 86400
512: INTO l_end_time FROM DUAL;
513:
514: x_return_status := 'S';
515: FOR cur_rec in end_date_cur (p_calendar_code, p_end_date)
516: LOOP

Line 1558: FROM sys.dual

1554: l_date DATE;
1555:
1556: CURSOR Is_WorkDayTime (p_calendar_id VARCHAR2 , p_cal_date DATE) IS
1557: SELECT 1
1558: FROM sys.dual
1559: WHERE EXISTS (
1560: select 'x'
1561: FROM bom_calendars bd,
1562: bom_shift_dates sd,