APPS.PON_VALIDATE_PAYMENTS_INT dependencies on PON_BID_HEADERS

Line 543: PON_BID_HEADERS pbh

539: PON_AUCTION_HEADERS_ALL pah,
540: MTL_UNITS_OF_MEASURE uom,
541: PO_LOOKUP_CODES fl,
542: FND_CURRENCIES fc,
543: PON_BID_HEADERS pbh
544: WHERE pbp.auction_header_id = pai.auction_header_id (+)
545: AND pbp.document_disp_line_number = pai.document_disp_line_number (+)
546: AND pbp.batch_id = p_batch_id
547: AND pbp.auction_header_id = p_auction_header_id

Line 1326: l_rate pon_bid_headers.rate%TYPE;

1322: x_result OUT NOCOPY VARCHAR2, -- S: Success, E: failure
1323: x_error_code OUT NOCOPY VARCHAR2,
1324: x_error_message OUT NOCOPY VARCHAR2)
1325: IS
1326: l_rate pon_bid_headers.rate%TYPE;
1327: l_sequence NUMBER :=0;
1328: l_previous_line_number NUMBER := -99;
1329: l_module CONSTANT VARCHAR2(32) := 'COPY_PAYMENTS_FROM_INT_TO_TXN';
1330: l_progress varchar2(200);

Line 1374: FROM pon_bid_headers pbh,

1370:
1371: -- select some variables that we need for currency conversion
1372: SELECT distinct pbh.rate
1373: INTO l_rate
1374: FROM pon_bid_headers pbh,
1375: pon_bid_payments_interface pbpi
1376: WHERE pbpi.bid_number = pbh.bid_number
1377: AND pbpi.batch_id = p_batch_id;
1378: