APPS.GMD_QC_MIG12 dependencies on PO_VENDOR_SITES_ALL

Line 2919: FROM po_vendor_sites_all

2915: -- Added code to update Operating Unit Information for Supplier Samples
2916: l_org_id := NULL;
2917: IF v_samp_rec.supplier_site_id IS NOT NULL AND v_samp_rec.source = 'S' THEN
2918: SELECT org_id INTO l_org_id
2919: FROM po_vendor_sites_all
2920: WHERE vendor_site_id = v_samp_rec.supplier_site_id;
2921: ELSE
2922: l_org_id := v_samp_rec.org_id;
2923: END IF;

Line 5966: FROM po_vendor_sites_all

5962: l_supl_org_id := NULL;
5963: IF l_supl_spec.supplier_site_id IS NOT NULL THEN
5964: BEGIN
5965: SELECT org_id INTO l_supl_org_id
5966: FROM po_vendor_sites_all
5967: WHERE vendor_site_id = l_supl_spec.supplier_site_id;
5968: EXCEPTION
5969: WHEN OTHERS THEN
5970: l_supl_org_id := NULL;