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 614: from pon_bidding_parties

610: BEGIN
611:
612: select sequence
613: into v_supplier_seq_number
614: from pon_bidding_parties
615: where auction_header_id = p_auction_header_id and
616: ((trading_partner_id = p_trading_partner_id and
617: vendor_site_id = p_vendor_site_id) OR
618: requested_supplier_id = p_requested_supplier_id);