DBA Data[Home] [Help]

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 1491: FROM sys.dual

1487: l_date DATE;
1488:
1489: CURSOR Is_WorkDayTime (p_calendar_id VARCHAR2 , p_cal_date DATE) IS
1490: SELECT 1
1491: FROM sys.dual
1492: WHERE EXISTS (
1493: select 'x'
1494: FROM bom_calendars bd,
1495: bom_shift_dates sd,