DBA Data[Home] [Help]

APPS.PON_AUCTION_PKG dependencies on PON_EMD_TRANSACTIONS

Line 973: SELECT 'Y' INTO x_emd_received_flag FROM pon_emd_transactions

969: AND TRADING_PARTNER_ID = bidder.trading_partner_id
970: AND vendor_site_id = bidder.vendor_site_id;
971:
972:
973: SELECT 'Y' INTO x_emd_received_flag FROM pon_emd_transactions
974: WHERE auction_header_id = (SELECT Decode(Nvl(auction_header_id_prev_round,0),0,Nvl(auction_header_id_prev_amend,0),auction_header_id_prev_round)
975: FROM pon_auction_headers_all
976: WHERE auction_header_id = x_auction_header_id)
977: AND SUPPLIER_SEQUENCE = x_supplier_sequence

Line 4103: SELECT 'Y' INTO x_emd_received_flag FROM pon_emd_transactions

4099: AND TRADING_PARTNER_ID = x_prev_trading_partner_id
4100: AND vendor_site_id = x_prev_supplier_site_id;
4101:
4102:
4103: SELECT 'Y' INTO x_emd_received_flag FROM pon_emd_transactions
4104: WHERE auction_header_id = x_doc_header_id_prev_round
4105: AND SUPPLIER_SEQUENCE = x_supplier_sequence
4106: AND STATUS_LOOKUP_CODE = 'RECEIVED';
4107: