125: END IF;
126: WHEN 'ST' THEN
127: SELECT 'ST:'||vendor_type_lookup_code
128: INTO st_code
129: FROM AP_SUPPLIERS
130: WHERE party_id = p_party_id;
131: IF (class_code = st_code) THEN
132: return_code := class_code;
133: END IF;
383: , l_evaluation_flag
384: FROM PON_BID_HEADERS PON
385: , HZ_PARTIES HZ1
386: , HZ_PARTIES HZ2
387: , AP_SUPPLIERS AP
388: WHERE PON.AUCTION_HEADER_ID = p_auction_header_id
389: AND PON.BID_NUMBER = p_bid_number
390: AND HZ1.PARTY_ID (+) = PON.EVALUATOR_ID
391: AND HZ2.PARTY_ID (+) = PON.TRADING_PARTNER_CONTACT_ID