DBA Data[Home] [Help]

APPS.PO_REQS_SV dependencies on PO_REQ_DISTRIBUTIONS

Line 177: FROM po_req_distributions

173:
174: X_progress VARCHAR2(3) := '';
175:
176: cursor c1 is SELECT 'Y'
177: FROM po_req_distributions
178: WHERE requisition_line_id
179: IN (SELECT requisition_line_id
180: FROM po_requisition_lines
181: WHERE requisition_header_id = X_req_hdr_id)

Line 281: DELETE FROM po_req_distributions

277:
278: -- dbms_output.put_line('Before open cursor');
279:
280: FOR Srec IN S LOOP
281: DELETE FROM po_req_distributions
282: WHERE requisition_line_id = Srec.requisition_line_id;
283:
284: x_progress := '020';
285: