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 3253: FROM dual

3249: l_dummy NUMBER;
3250:
3251: CURSOR c_period (l_name IN VARCHAR2) IS
3252: SELECT 1
3253: FROM dual
3254: WHERE EXISTS (
3255: SELECT 1
3256: FROM gl_periods_v
3257: WHERE period_set_name = p_deliv_rec.deliverable_calendar

Line 3402: FROM dual

3398: l_fore_comp_date DATE;
3399:
3400: CURSOR c_calendar (l_calendar_name IN VARCHAR2) IS
3401: SELECT 1
3402: FROM dual
3403: WHERE EXISTS (SELECT 1
3404: FROM gl_periods_v
3405: WHERE period_set_name = l_calendar_name);
3406: