APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on HZ_CUST_ACCOUNTS

Line 1452: l_account_id hz_cust_accounts.cust_account_id%TYPE;

1448: l_tax_prof_name VARCHAR(30);
1449: l_rounding_level_basis VARCHAR(8);
1450: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1451: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1452: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1453: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1454: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1455: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1456: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;

Line 1683: l_account_id hz_cust_accounts.cust_account_id%TYPE;

1679: l_rounding_level_basis VARCHAR(8);
1680:
1681: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1682: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1683: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1684: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1685: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1686: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1687: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;

Line 8162: ,hz_cust_accounts caa

8158: nvl(csu.tax_header_level_flag, caa.tax_header_level_flag) tax_header_level_flag,
8159: csu.Tax_Classification
8160: FROM hz_cust_site_uses_all csu
8161: ,hz_cust_acct_sites cas
8162: ,hz_cust_accounts caa
8163: WHERE csu.site_use_id = c_site_use_id
8164: AND csu.cust_acct_site_id = c_account_site_id
8165: AND csu.cust_acct_site_id = cas.cust_acct_site_id
8166: AND cas.cust_account_id = caa.cust_account_id

Line 8284: FROM hz_cust_accounts

8280: SELECT
8281: tax_code,
8282: tax_header_level_flag,
8283: tax_rounding_rule
8284: FROM hz_cust_accounts
8285: WHERE cust_account_id = c_account_id;
8286:
8287: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8288: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;