DBA Data[Home] [Help]

APPS.AMW_CONTROL_PVT dependencies on DUAL

Line 517: FROM DUAL;

513: l_control_rec control_rec_type;
514: l_control_id NUMBER;
515: CURSOR c_id IS
516: SELECT amw_controls_s.NEXTVAL
517: FROM DUAL;
518: CURSOR c_rev_id IS
519: SELECT amw_control_rev_s.NEXTVAL
520: FROM DUAL;
521: CURSOR c_id_exists (l_id IN NUMBER) IS

Line 520: FROM DUAL;

516: SELECT amw_controls_s.NEXTVAL
517: FROM DUAL;
518: CURSOR c_rev_id IS
519: SELECT amw_control_rev_s.NEXTVAL
520: FROM DUAL;
521: CURSOR c_id_exists (l_id IN NUMBER) IS
522: SELECT 1
523: FROM amw_controls_b
524: WHERE control_id = l_id;