APPS.PON_VALIDATE_PAYMENTS_INT dependencies on PON_BID_ITEM_PRICES_INTERFACE

Line 1318: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,

1314: END validate_creation;
1315: --
1316:
1317: PROCEDURE copy_payments_from_int_to_txn(
1318: p_batch_id IN pon_bid_item_prices_interface.batch_id%TYPE,
1319: p_spreadsheet_type IN VARCHAR2,
1320: p_bid_number IN NUMBER,
1321: p_auction_header_id IN NUMBER,
1322: x_result OUT NOCOPY VARCHAR2, -- S: Success, E: failure

Line 1522: AND pbp.bid_line_number IN (SELECT pbi.line_number FROM PON_BID_ITEM_PRICES_INTERFACE pbi WHERE pbi.batch_id = p_batch_id);

1518: AND pai.auction_header_id = pbpi.auction_header_id
1519: AND pai.document_disp_line_number = pbpi.document_disp_line_number
1520: AND pbp.bid_line_number = pai.line_number)
1521: AND pbp.bid_number = p_bid_number
1522: AND pbp.bid_line_number IN (SELECT pbi.line_number FROM PON_BID_ITEM_PRICES_INTERFACE pbi WHERE pbi.batch_id = p_batch_id);
1523:
1524: -- To delete attachments of pon_bid_payments_shipments
1525: FOR delete_pymt_attachments_record IN delete_pymt_attachments_cursor
1526: LOOP