DBA Data[Home] [Help]

APPS.JTF_RS_GROUPS_PVT dependencies on DUAL

Line 284: FROM dual;

280:
281: LOOP
282: SELECT jtf_rs_groups_s.nextval
283: INTO l_group_id
284: FROM dual;
285: --dbms_output.put_line ('After Select - Group ID ' || l_group_id);
286:
287: OPEN c_dup_group_id (l_group_id);
288: FETCH c_dup_group_id INTO l_check_dup_id;

Line 303: FROM dual;

299: /* Get the next value of the Group number from the sequence. */
300:
301: SELECT jtf_rs_group_number_s.nextval
302: INTO l_group_number
303: FROM dual;
304:
305: /* Make a call to the group Audit API */
306:
307: jtf_rs_groups_aud_pvt.insert_group