DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on PO_VENDORS

Line 7161: PO_VENDORS PV

7157: BEGIN
7158: SELECT
7159: DISTINCT PBP.trading_partner_name BULK COLLECT INTO l_inactive_suppliers
7160: FROM PON_BIDDING_PARTIES PBP,
7161: PO_VENDORS PV
7162: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
7163: AND PV.PARTY_ID = PBP.TRADING_PARTNER_ID
7164: AND ( nvl(pv.start_date_active, sysdate) > sysdate OR
7165: nvl(pv.end_date_active, sysdate) < sysdate );