APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PON_BIDDING_PARTIES

Line 76: CURSOR c_pon_bidding_parties IS

72: AND (p_document_id,p_document_type, bh.trading_partner_id, Nvl(bh.vendor_site_id,-99)) NOT IN (SELECT doc_id, doc_type, vdr_elgb.vendor_id, Nvl(vdr_elgb.vendor_site_id,-99) FROM po_vendor_eligibility vdr_elgb);
73:
74:
75:
76: CURSOR c_pon_bidding_parties IS
77: SELECT p_document_id doc_id,
78: p_document_type doc_type,
79: NULL draft_id,
80: 'N' select_flag,

Line 94: FROM PON_BIDDING_PARTIES suppliers, PO_VENDORS vendor

90: NULL performed_by,
91: NULL Error,
92: NULL approved_without_check,
93: NULL Reason
94: FROM PON_BIDDING_PARTIES suppliers, PO_VENDORS vendor
95: WHERE suppliers.auction_header_id = p_document_id
96: AND suppliers.trading_partner_id = vendor.vendor_id(+)
97: AND (p_document_id, p_document_type, suppliers.trading_partner_id, Nvl(suppliers.vendor_site_id, -99)) NOT IN (SELECT doc_id, doc_type, vdr_elgb.vendor_id, Nvl(vdr_elgb.vendor_site_id,-99) FROM po_vendor_eligibility vdr_elgb);
98:

Line 132: FROM PON_BIDDING_PARTIES suppliers

128: WHERE ah.auction_header_id = p_document_id
129: AND ah.auction_header_id = bh.auction_header_id(+)
130: )
131: AND (vdr.vendor_id , Nvl(vdr.vendor_site_id, -99)) NOT IN (SELECT suppliers.trading_partner_id , Nvl(suppliers.vendor_site_id,-99)
132: FROM PON_BIDDING_PARTIES suppliers
133: WHERE suppliers.auction_header_id = p_document_id
134: );
135:
136: CURSOR sol_vendor_check_history IS

Line 339: FOR c IN c_pon_bidding_parties LOOP

335: );
336:
337: END LOOP;
338:
339: FOR c IN c_pon_bidding_parties LOOP
340:
341:
342: INSERT INTO po_vendor_eligibility
343: (

Line 876: (vendor_id IN (SELECT trading_partner_id FROM PON_BIDDING_PARTIES WHERE auction_header_id = p_auction_header_id)));

872: AND doc_type = 'SOLICITATION'
873: --AND vendor_id IN (SELECT trading_partner_id FROM pon_bid_headers WHERE auction_header_id = p_auction_header_id AND award_status IN ('AWARDED','PARTIAL'));
874: AND ((vendor_id IN (SELECT trading_partner_id FROM pon_bid_headers WHERE auction_header_id = p_auction_header_id))
875: OR
876: (vendor_id IN (SELECT trading_partner_id FROM PON_BIDDING_PARTIES WHERE auction_header_id = p_auction_header_id)));
877:
878: l_no_rec VARCHAR2(1):='Y';
879:
880: BEGIN