DBA Data[Home] [Help]

APPS.PON_TRANSFORM_BIDDING_PKG dependencies on PON_BIDDING_PARTIES

Line 57: FROM pon_bidding_parties

53:
54: SELECT vendor_site_id
55: INTO v_site_id
56: FROM (SELECT vendor_site_id
57: FROM pon_bidding_parties
58: WHERE auction_header_id = p_auction_header_id
59: AND trading_partner_id = p_tpid
60: ORDER BY vendor_site_code)
61: WHERE rownum=1;

Line 522: from pon_bidding_parties

518: BEGIN
519:
520: select sequence
521: into v_supplier_seq_number
522: from pon_bidding_parties
523: where auction_header_id = p_auction_header_id and
524: ((trading_partner_id = p_trading_partner_id and
525: vendor_site_id = p_vendor_site_id) OR
526: requested_supplier_id = p_requested_supplier_id);