APPS.OKL_PROCESS_SALES_TAX_PVT dependencies on PO_VENDOR_SITES

Line 7789: FROM po_vendor_sites

7785:
7786: -- get the primary pay vendor location for the vendor
7787: CURSOR l_povendorsites_csr(cp_vendor_id IN NUMBER) IS
7788: SELECT vendor_site_id
7789: FROM po_vendor_sites
7790: WHERE vendor_id = cp_vendor_id
7791: AND primary_pay_site_flag = 'Y';
7792:
7793:

Line 8371: FROM po_vendor_sites

8367:
8368: -- get the primary pay vendor location for the vendor
8369: CURSOR l_povendorsites_csr(cp_vendor_id IN NUMBER) IS
8370: SELECT vendor_site_id
8371: FROM po_vendor_sites
8372: WHERE vendor_id = cp_vendor_id
8373: AND primary_pay_site_flag = 'Y';
8374:
8375: -- check if stream element is billed in AR

Line 15906: FROM po_vendor_sites

15902:
15903: -- Get the primary pay vendor location for the vendor
15904: CURSOR l_povendorsites_csr(cp_vendor_id IN NUMBER) IS
15905: SELECT vendor_site_id
15906: FROM po_vendor_sites
15907: WHERE vendor_id = cp_vendor_id
15908: AND primary_pay_site_flag = 'Y';
15909:
15910: -- Cursor to get the corresponding hz_location id for the install location id

Line 19191: FROM po_vendor_sites

19187: AND line.tap_id = hdr.id;
19188:
19189: CURSOR l_get_vendor_csr(cp_vendor_site_id IN NUMBER) IS
19190: SELECT vendor_id
19191: FROM po_vendor_sites
19192: WHERE vendor_site_id = cp_vendor_site_id;
19193:
19194: -- Record types
19195: l_billingdtls_rec l_billingdtls_csr%ROWTYPE;