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 467: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA

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

Line 646: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA

642: l_tax_code ZX_ID_TCC_MAPPING.TAX_CLASSIFICATION_CODE%TYPE;
643:
644: CURSOR cur_address(cp_site_use_id IN VARCHAR2, cp_code VARCHAR2) IS
645: SELECT CS.SITE_USE_ID, CS.ORG_ID, CA.CUST_ACCOUNT_ID, CA.CUST_ACCT_SITE_ID
646: FROM HZ_CUST_SITE_USES_ALL CS, HZ_CUST_ACCT_SITES_ALL CA
647: WHERE CS.SITE_USE_ID = cp_site_use_id AND CS.SITE_USE_CODE = cp_code
648: AND CA.CUST_ACCT_SITE_ID = CS.CUST_ACCT_SITE_ID;
649: ADDRESS_REC cur_address%ROWTYPE;
650:

Line 917: HZ_CUST_SITE_USES_ALL S_SHIP,

913: PARTY_SITE_SHIP.PARTY_SITE_ID,
914: PARTY_SITE_SHIP.LOCATION_ID,
915: LOC_SHIP.STATE
916: FROM
917: HZ_CUST_SITE_USES_ALL S_SHIP,
918: HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
919: HZ_PARTY_SITES PARTY_SITE_SHIP,
920: HZ_LOCATIONS LOC_SHIP,
921: --HZ_LOC_ASSIGNMENTS LOC_ASSIGN_SHIP,