APPS.ZX_TCM_CONTROL_PKG dependencies on HZ_CUST_ACCOUNTS

Line 2166: ,hz_cust_accounts caa

2162: ,nvl(csu.tax_header_level_flag, caa.tax_header_level_flag) tax_header_level_flag
2163: ,csu.Tax_Classification
2164: FROM hz_cust_site_uses_all csu
2165: ,hz_cust_acct_sites cas
2166: ,hz_cust_accounts caa
2167: WHERE csu.site_use_id = p_site_use_id
2168: AND csu.cust_acct_site_id = p_account_site_id
2169: AND csu.cust_acct_site_id = cas.cust_acct_site_id
2170: AND cas.cust_account_id = caa.cust_account_id

Line 2302: hz_cust_accounts caa

2298: caa.tax_code tax_code
2299: ,caa.tax_rounding_rule tax_rounding_rule
2300: ,caa.tax_header_level_flag tax_header_level_flag
2301: FROM
2302: hz_cust_accounts caa
2303: WHERE caa.cust_account_id = p_account_id;
2304:
2305: BEGIN
2306:

Line 2621: -- or hz_cust_accounts or hz_cust_site_uses

2617: END IF; -- if5
2618: END IF; -- if4
2619: END IF; -- if3 p_site_ptp_id id not null
2620: -- Check if we can get the registration information from ap_supplier_sites_all
2621: -- or hz_cust_accounts or hz_cust_site_uses
2622: --
2623: IF (p_account_id is not NULL) and (p_account_site_id IS NOT NULL) THEN -- if6
2624: -- Check party type code
2625: IF p_account_type_code = 'SUPPLIER' THEN -- if7