DBA Data[Home] [Help]

APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on PO_VENDOR_SITES_ALL

Line 306: FROM po_vendor_sites_all

302: CURSOR vendor_site_csr( p_vendor_id IN NUMBER,
303: p_vendor_site_id IN NUMBER,
304: p_vendor_site_code IN VARCHAR2 ) IS
305: SELECT VENDOR_SITE_ID
306: FROM po_vendor_sites_all
307: WHERE VENDOR_ID = p_vendor_id
308: AND (VENDOR_SITE_ID = p_vendor_site_id OR VENDOR_SITE_CODE = p_vendor_site_code);
309:
310: ------------------------------------------------------------

Line 1033: FROM po_vendor_sites_all b

1029: END IF;
1030: forall indx in l_rowid_tbl.first..l_rowid_tbl.last
1031: update okl_ext_billing_interface a
1032: set TAX_VENDOR_SITE_ID = (SELECT VENDOR_SITE_ID
1033: FROM po_vendor_sites_all b
1034: WHERE b.VENDOR_ID = a.TAX_VENDOR_ID
1035: AND b.VENDOR_SITE_CODE = a.TAX_VENDOR_SITE_NAME
1036: AND b.ORG_ID = a.ORG_ID ) --6144718
1037: where rowid = l_rowid_tbl(indx)