APPS.IGC_CC_OPN_UPD_GET_LNK_PUB dependencies on PO_VENDOR_SITES_ALL

Line 1155: FROM po_vendor_sites_all

1151: INTO l_vendor_site_id,
1152: l_vendor_site_curr_code,
1153: l_populate_terms_id,
1154: l_billed_to_location_id
1155: FROM po_vendor_sites_all
1156: WHERE org_id = p_cc_header_rec.org_id /* Addded this condition for MOAC uptake */
1157: AND vendor_site_id = p_cc_header_rec.vendor_site_id
1158: AND vendor_id = p_cc_header_rec.vendor_id
1159: AND purchasing_site_flag = 'Y'