APPS.PON_CLM_CLO_UTIL_PKG dependencies on PON_BACKING_REQUISITIONS

Line 324: AND NOT EXISTS(SELECT 'Y' FROM pon_backing_requisitions

320: message => 'This is a clin.Checking previously deleted slins/options to return them to req pool ');
321: END IF;
322: FOR rec IN (SELECT requisition_line_id FROM po_requisition_lines_all prl WHERE requisition_header_id = x_req_hdr_id
323: AND (group_line_id = x_req_line_id OR clm_base_line_num = x_req_line_id)
324: AND NOT EXISTS(SELECT 'Y' FROM pon_backing_requisitions
325: WHERE requisition_header_id = x_req_hdr_id
326: AND requisition_line_id = prl.requisition_line_id)) LOOP
327: update po_requisition_lines_all prla --Bug 4001965: use _all
328: set auction_header_id = null,

Line 1612: FROM pon_backing_requisitions pbr,

1608: prh.preparer_id,
1609: 'SOLICITATION',
1610: prl.item_description,
1611: NULL -- Buyer ID
1612: FROM pon_backing_requisitions pbr,
1613: pon_auction_item_prices_all paip,
1614: pon_auction_headers_all pah,
1615: po_requisition_lines_all prl,
1616: po_requisition_headers_all prh