DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on POS_SUPPLIER_REGISTRATIONS

Line 4198: FROM pon_bid_headers bh, pos_supplier_registrations psr

4194: IF (l_supp_end_date IS null) THEN
4195: BEGIN
4196: SELECT sysdate
4197: INTO l_supp_end_date
4198: FROM pon_bid_headers bh, pos_supplier_registrations psr
4199: WHERE bh.auction_header_id = p_auc_header_id
4200: AND bh.trading_partner_id = p_tpid
4201: AND psr.supplier_reg_id = bh.trading_partner_id
4202: AND psr.registration_status in ('RIF_SUPPLIER', 'PENDING_APPROVAL') -- Bug 9037236