APPS.CSP_REPAIR_PO_GRP dependencies on DUAL

Line 116: SELECT Sysdate INTO l_today FROM dual;

112:
113: l_defective_parts_tbl := p_defective_parts_tbl;
114:
115: /* -------- User and Login Information -------- */
116: SELECT Sysdate INTO l_today FROM dual;
117: l_user_id := fnd_global.user_id;
118: l_login_id := fnd_global.login_id;
119:
120: /* --------- Start Create Reservations for Defective Parts passed ----------- */

Line 324: from dual;

320: End;
321:
322: select csp_repair_po_headers_s1.nextval
323: into l_repair_po_header_id
324: from dual;
325:
326: /* In "CSP_PARTS_ORDER.PROCESS_PURCHASE_REQ" API inserting into
327: "PO_REQUISITIONS_INTERFACE_ALL" table SOURCE_TYPE_CODE as "VENDOR".
328: So this item must be Purchasing_enabled in both Repair supplier org and destination org. */

Line 496: from dual;

492:
493: /*
494: select po_notes_s.nextval
495: into p_note_id
496: from dual;
497:
498: Insert into PO_NOTES
499: (
500: PO_NOTE_ID

Line 697: from dual;

693: l_out_reservation_rec := l_out_reservation_tbl(I);
694:
695: select csp_repair_po_lines_s1.nextval
696: into l_repair_po_line_id
697: from dual;
698:
699: INSERT INTO CSP_REPAIR_PO_LINES
700: (
701: REPAIR_PO_LINE_ID