APPS.PON_NEGOTIATION_COPY_GRP dependencies on POS_SUPPLIER_REGISTRATIONS

Line 5624: SELECT supplier_reg_id FROM pos_supplier_registrations

5620: FROM PON_BIDDING_PARTIES PBP
5621: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5622: AND PBP.trading_partner_id IS NULL
5623: AND pbp.requested_supplier_id NOT IN (
5624: SELECT supplier_reg_id FROM pos_supplier_registrations
5625: WHERE registration_status = 'REJECTED')
5626: ) A;
5627: --} End of if Copy Negotiation
5628: ELSE -- new round

Line 5797: FROM pos_supplier_registrations

5793: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
5794: AND PBP.trading_partner_id IS NULL
5795: AND PBP.requested_supplier_id NOT IN (
5796: SELECT supplier_reg_id
5797: FROM pos_supplier_registrations
5798: WHERE registration_status = 'REJECTED')
5799: UNION -- suppliers from bid headers
5800: SELECT
5801: -1 as LIST_ID,

Line 6082: Pos_supplier_registrations posreg

6078: --l_inactive_suppliers := NULL;
6079: BEGIN
6080: SELECT DISTINCT PBP.requested_supplier_name BULK COLLECT INTO l_inactive_suppliers
6081: FROM PON_BIDDING_PARTIES PBP,
6082: Pos_supplier_registrations posreg
6083: WHERE PBP.AUCTION_HEADER_ID = p_source_auction_header_id
6084: AND posreg.SUPPLIER_REG_ID = pbp.REQUESTED_SUPPLIER_ID
6085: AND posreg.REGISTRATION_STATUS = 'REJECTED';
6086: EXCEPTION WHEN no_data_found THEN