APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1442: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

1438: )
1439: IS
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;

Line 1673: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

1669: l_tax_prof_id ZX_PARTY_TAX_PROFILE.PARTY_TAX_PROFILE_ID%TYPE;
1670: l_tax_prof_name VARCHAR(30);
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;

Line 7894: ,hz_cust_acct_sites cas

7890: nvl(csu.Tax_Rounding_rule,caa.tax_rounding_rule) tax_rounding_rule,
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