APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PO_VENDOR_ELIGIBILITY_H

Line 159: FROM po_vendor_eligibility_h vdr

155: last_updated_by,
156: creation_date,
157: created_by,
158: last_update_login
159: FROM po_vendor_eligibility_h vdr
160: WHERE vdr.doc_id IN (SELECT auction_header_id FROM pon_bid_item_prices WHERE po_header_id = p_document_id)
161: AND vdr.doc_type = 'SOLICITATION'
162: AND vdr.vendor_id = (SELECT vendor_id FROM po_vendor_eligibility WHERE doc_id = p_document_id AND draft_id = p_draft_id)
163: AND Nvl(vdr.vendor_site_id,-99) = (SELECT Nvl(vendor_site_id,-99) FROM po_vendor_eligibility WHERE doc_id = p_document_id AND draft_id = p_draft_id);

Line 226: INSERT INTO po_vendor_eligibility_h

222: END LOOP;
223:
224: FOR c IN sol_vendor_check_history LOOP
225:
226: INSERT INTO po_vendor_eligibility_h
227: (
228: id ,
229: doc_id ,
230: doc_type ,

Line 397: INSERT INTO po_vendor_eligibility_h

393: END LOOP;
394:
395: FOR c IN c_pon_movetohistory LOOP
396:
397: INSERT INTO po_vendor_eligibility_h
398: (
399: id ,
400: doc_id ,
401: doc_type ,

Line 661: INSERT INTO po_vendor_eligibility_h

657:
658: FOR c IN c_get_selected_suppliers LOOP
659:
660: IF c.eligibility_status IS NOT NULL OR l_error IS NOT NULL THEN
661: INSERT INTO po_vendor_eligibility_h
662: (
663: id ,
664: doc_id ,
665: doc_type ,

Line 689: SELECT po_vendor_eligibility_h_s.NEXTVAL,

685: creation_date ,
686: created_by ,
687: last_update_login
688: )
689: SELECT po_vendor_eligibility_h_s.NEXTVAL,
690: doc_id,
691: doc_type,
692: draft_id,
693: select_flag,