APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on PO_VENDOR_CONTACTS
Line 1213: FROM po_vendor_contacts
1209:
1210: BEGIN
1211: SELECT vendor_contact_id
1212: INTO l_vendor_contact_id 1213: FROM po_vendor_contacts 1214: WHERE vendor_site_id = p_cc_header_rec.vendor_site_id
1215: AND vendor_contact_id = p_cc_header_rec.vendor_contact_id
1216: AND NVL(inactive_date, sysdate+1) > sysdate;
1217: