APPS.PON_NEGOTIATION_COPY_GRP dependencies on POS_SUPPLIER_REGISTRATIONS

Line 6765: SELECT supplier_reg_id FROM pos_supplier_registrations

6761: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6762: AND NVL(PBP.from_emd_flag,'N') <> 'Y'-- Added by Lion for EMD on 04/02/2009
6763: AND PBP.trading_partner_id IS NULL
6764: AND pbp.requested_supplier_id NOT IN (
6765: SELECT supplier_reg_id FROM pos_supplier_registrations
6766: WHERE registration_status = 'REJECTED')
6767: ) A;
6768: --} End of if Copy Negotiation
6769: ELSE -- new round

Line 6942: FROM pos_supplier_registrations

6938: --AND NVL(PBP.from_emd_flag,'N') <> 'Y' -- Added by Lion for EMD on 04/02/2009
6939: AND PBP.trading_partner_id IS NULL
6940: AND PBP.requested_supplier_id NOT IN (
6941: SELECT supplier_reg_id
6942: FROM pos_supplier_registrations
6943: WHERE registration_status = 'REJECTED')
6944: UNION -- suppliers from bid headers
6945: SELECT
6946: -1 as LIST_ID,

Line 7228: Pos_supplier_registrations posreg

7224: --l_inactive_suppliers := NULL;
7225: BEGIN
7226: SELECT DISTINCT PBP.requested_supplier_name BULK COLLECT INTO l_inactive_suppliers
7227: FROM PON_BIDDING_PARTIES PBP,
7228: Pos_supplier_registrations posreg
7229: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
7230: AND posreg.SUPPLIER_REG_ID = pbp.REQUESTED_SUPPLIER_ID
7231: AND posreg.REGISTRATION_STATUS = 'REJECTED';
7232: EXCEPTION WHEN no_data_found THEN