APPS.AMS_DELIVERABLE_PVT dependencies on DUAL

Line 232: FROM DUAL;

228: l_task_planned_start_date DATE := SYSDATE;
229:
230: CURSOR c_deliv_seq IS
231: SELECT ams_deliverables_all_b_s.NEXTVAL
232: FROM DUAL;
233:
234: CURSOR c_deliv_count(deliv_id IN NUMBER) IS
235: SELECT COUNT(*)
236: FROM ams_deliverables_vl

Line 3240: FROM dual

3236: l_dummy NUMBER;
3237:
3238: CURSOR c_period (l_name IN VARCHAR2) IS
3239: SELECT 1
3240: FROM dual
3241: WHERE EXISTS (
3242: SELECT 1
3243: FROM gl_periods_v
3244: WHERE period_set_name = p_deliv_rec.deliverable_calendar

Line 3389: FROM dual

3385: l_fore_comp_date DATE;
3386:
3387: CURSOR c_calendar (l_calendar_name IN VARCHAR2) IS
3388: SELECT 1
3389: FROM dual
3390: WHERE EXISTS (SELECT 1
3391: FROM gl_periods_v
3392: WHERE period_set_name = l_calendar_name);
3393: