APPS.OKS_TAX_UTIL_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 246: FROM HZ_CUST_SITE_USES_ALL S_SHIP,

242:
243:
244: CURSOR cust_acct_csr(cp_site_use_id NUMBER) IS
245: SELECT ACCT_SITE_SHIP.CUST_ACCOUNT_ID
246: FROM HZ_CUST_SITE_USES_ALL S_SHIP,
247: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP
248: WHERE S_SHIP.SITE_USE_ID = cp_site_use_id
249: AND S_SHIP.CUST_ACCT_SITE_ID = acct_site_ship.cust_acct_site_id;
250:

Line 469: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA

465: x_hook NUMBER;
466:
467: CURSOR cur_address(cp_site_use_id IN VARCHAR2, cp_code VARCHAR2) IS
468: SELECT CS.SITE_USE_ID, CS.ORG_ID, CA.CUST_ACCOUNT_ID, CA.CUST_ACCT_SITE_ID
469: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA
470: WHERE CS.SITE_USE_ID = cp_site_use_id AND CS.SITE_USE_CODE = cp_code
471: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID;
472: ADDRESS_REC cur_address%ROWTYPE;
473:

Line 666: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA

662: l_tax_code ZX_ID_TCC_MAPPING.TAX_CLASSIFICATION_CODE%TYPE;
663:
664: CURSOR cur_address(cp_site_use_id IN VARCHAR2, cp_code VARCHAR2) IS
665: SELECT CS.SITE_USE_ID, CS.ORG_ID, CA.CUST_ACCOUNT_ID, CA.CUST_ACCT_SITE_ID
666: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA
667: WHERE CS.SITE_USE_ID = cp_site_use_id AND CS.SITE_USE_CODE = cp_code
668: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID;
669: ADDRESS_REC cur_address%ROWTYPE;
670:

Line 951: HZ_CUST_SITE_USES_ALL S_SHIP,

947: PARTY_SITE_SHIP.PARTY_SITE_ID,
948: PARTY_SITE_SHIP.LOCATION_ID,
949: LOC_SHIP.STATE
950: FROM
951: HZ_CUST_SITE_USES_ALL S_SHIP,
952: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
953: HZ_PARTY_SITES PARTY_SITE_SHIP,
954: HZ_LOCATIONS LOC_SHIP,
955: --HZ_LOC_ASSIGNMENTS LOC_ASSIGN_SHIP,