DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PO_VENDORS

Line 4157: FROM pon_bid_headers bh, po_vendors pov

4153: if (p_buyer_user='Y')
4154: then
4155: SELECT nvl(pov.end_date_active, sysdate)
4156: INTO l_supp_end_date
4157: FROM pon_bid_headers bh, po_vendors pov
4158: WHERE bh.auction_header_id = p_auc_header_id
4159: AND bh.trading_partner_id = p_tpid
4160: --AND bh.trading_partner_contact_id = p_tpcid -- Modified for ER: Supplier Management: Supplier Evaluation
4161: AND ((l_eval_flag = 'N' AND bh.trading_partner_contact_id = p_tpcid) OR

Line 4172: FROM pon_bid_headers bh, po_vendors pov

4168: AND ROWNUM = 1; -- Multiple Active Offers : Multiple draft offers may exist, just get the first draft offer.
4169: else
4170: SELECT nvl(pov.end_date_active, sysdate)
4171: INTO l_supp_end_date
4172: FROM pon_bid_headers bh, po_vendors pov
4173: WHERE bh.auction_header_id = p_auc_header_id
4174: AND bh.trading_partner_id = p_tpid
4175: --AND bh.trading_partner_contact_id = p_tpcid -- Modified for ER: Supplier Management: Supplier Evaluation
4176: AND ((l_eval_flag = 'N' AND bh.trading_partner_contact_id = p_tpcid) OR