APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on HZ_CUST_ACCOUNTS

Line 1444: l_account_id hz_cust_accounts.cust_account_id%TYPE;

1440: l_tax_prof_name VARCHAR(30);
1441: l_rounding_level_basis VARCHAR(8);
1442: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1443: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1444: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1445: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1446: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1447: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1448: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;

Line 1675: l_account_id hz_cust_accounts.cust_account_id%TYPE;

1671: l_rounding_level_basis VARCHAR(8);
1672:
1673: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;
1674: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1675: l_account_id hz_cust_accounts.cust_account_id%TYPE;
1676: l_parent_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1677: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1678: l_registration_rec zx_tcm_control_pkg.zx_registration_info_rec;
1679: l_tax_service_type_code zx_rules_b.service_type_code%TYPE;

Line 7895: ,hz_cust_accounts caa

7891: nvl(csu.tax_header_level_flag, caa.tax_header_level_flag) tax_header_level_flag,
7892: csu.Tax_Classification
7893: FROM hz_cust_site_uses_all csu
7894: ,hz_cust_acct_sites cas
7895: ,hz_cust_accounts caa
7896: WHERE csu.site_use_id = c_site_use_id
7897: AND csu.cust_acct_site_id = c_account_site_id
7898: AND csu.cust_acct_site_id = cas.cust_acct_site_id
7899: AND cas.cust_account_id = caa.cust_account_id

Line 8017: FROM hz_cust_accounts

8013: SELECT
8014: tax_code,
8015: tax_header_level_flag,
8016: tax_rounding_rule
8017: FROM hz_cust_accounts
8018: WHERE cust_account_id = c_account_id;
8019:
8020: l_tax_code hz_cust_site_uses_all.Tax_Code%TYPE;
8021: l_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;