APPS.PO_REQS_SV dependencies on PO_REQ_DISTRIBUTIONS

Line 171: FROM po_req_distributions

167:
168: X_progress VARCHAR2(3) := '';
169:
170: cursor c1 is SELECT 'Y'
171: FROM po_req_distributions
172: WHERE requisition_line_id
173: IN (SELECT requisition_line_id
174: FROM po_requisition_lines
175: WHERE requisition_header_id = X_req_hdr_id)

Line 275: DELETE FROM po_req_distributions

271:
272: -- dbms_output.put_line('Before open cursor');
273:
274: FOR Srec IN S LOOP
275: DELETE FROM po_req_distributions
276: WHERE requisition_line_id = Srec.requisition_line_id;
277:
278: x_progress := '020';
279: