APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on PO_VENDOR_SITES

Line 7758: FROM po_vendor_sites

7754:
7755: -- get the primary pay vendor location for the vendor
7756: CURSOR l_povendorsites_csr(cp_vendor_id IN NUMBER) IS
7757: SELECT vendor_site_id
7758: FROM po_vendor_sites
7759: WHERE vendor_id = cp_vendor_id
7760: AND primary_pay_site_flag = 'Y';
7761:
7762:

Line 8340: FROM po_vendor_sites

8336:
8337: -- get the primary pay vendor location for the vendor
8338: CURSOR l_povendorsites_csr(cp_vendor_id IN NUMBER) IS
8339: SELECT vendor_site_id
8340: FROM po_vendor_sites
8341: WHERE vendor_id = cp_vendor_id
8342: AND primary_pay_site_flag = 'Y';
8343:
8344: -- check if stream element is billed in AR

Line 15834: FROM po_vendor_sites

15830:
15831: -- Get the primary pay vendor location for the vendor
15832: CURSOR l_povendorsites_csr(cp_vendor_id IN NUMBER) IS
15833: SELECT vendor_site_id
15834: FROM po_vendor_sites
15835: WHERE vendor_id = cp_vendor_id
15836: AND primary_pay_site_flag = 'Y';
15837:
15838: -- Cursor to get the corresponding hz_location id for the install location id

Line 19024: FROM po_vendor_sites

19020: AND line.tap_id = hdr.id;
19021:
19022: CURSOR l_get_vendor_csr(cp_vendor_site_id IN NUMBER) IS
19023: SELECT vendor_id
19024: FROM po_vendor_sites
19025: WHERE vendor_site_id = cp_vendor_site_id;
19026:
19027: -- Record types
19028: l_billingdtls_rec l_billingdtls_csr%ROWTYPE;