APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1450: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

1446: )
1447: IS
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;

Line 1681: l_account_site_id hz_cust_acct_sites_all.cust_acct_site_id%TYPE;

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

Line 8161: ,hz_cust_acct_sites cas

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