APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on ZX_RATES_B

Line 51: l_tax_rate_id zx_rates_b.tax_rate_id%TYPE;

47: -- i number;
48: l_sum_basiscoef number;
49: l_sum_constcoef number;
50: l_tax_id number;
51: l_tax_rate_id zx_rates_b.tax_rate_id%TYPE;
52: l_compounding_tax_id number;
53: l_zx_result_rec ZX_PROCESS_RESULTS%ROWTYPE;
54: l_perc_discount number;
55: l_common_comp_base number;

Line 74: l_adj_for_adhoc_amt_code ZX_RATES_B.ADJ_FOR_ADHOC_AMT_CODE%TYPE;

70: l_Other_Charge_Appl_Flag ZX_FORMULA_B.Other_Charge_Appl_Flag%type;
71: l_enforce_compounding_flag ZX_FORMULA_DETAILS.ENFORCE_COMPOUNDING_FLAG%TYPE;
72:
73: l_allow_adhoc_tax_rate_flag VARCHAR2(1);
74: l_adj_for_adhoc_amt_code ZX_RATES_B.ADJ_FOR_ADHOC_AMT_CODE%TYPE;
75:
76: l_tax_determine_date date;
77: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
78: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;

Line 143: from zx_rates_b

139: */
140:
141: cursor getAdhocInfo( c_tax_rate_id IN NUMBER) is
142: select NVL(ADJ_FOR_ADHOC_AMT_CODE, 'TAXABLE_BASIS'), NVL(ALLOW_ADHOC_TAX_RATE_FLAG, 'N')
143: from zx_rates_b
144: where TAX_RATE_ID = c_tax_rate_id;
145:
146: CURSOR get_formula_code_from_rate_csr(
147: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

Line 147: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

143: from zx_rates_b
144: where TAX_RATE_ID = c_tax_rate_id;
145:
146: CURSOR get_formula_code_from_rate_csr(
147: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
148: SELECT taxable_basis_formula_code
149: FROM zx_rates_b
150: WHERE tax_rate_id = c_tax_rate_id;
151:

Line 149: FROM zx_rates_b

145:
146: CURSOR get_formula_code_from_rate_csr(
147: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
148: SELECT taxable_basis_formula_code
149: FROM zx_rates_b
150: WHERE tax_rate_id = c_tax_rate_id;
151:
152: BEGIN
153:

Line 1372: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

1368: l_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1369: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1370:
1371: CURSOR get_inclusive_flag_from_rate(
1372: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
1373: SELECT inclusive_tax_flag
1374: FROM zx_rates_b
1375: WHERE tax_rate_id = c_tax_rate_id;
1376:

Line 1374: FROM zx_rates_b

1370:
1371: CURSOR get_inclusive_flag_from_rate(
1372: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
1373: SELECT inclusive_tax_flag
1374: FROM zx_rates_b
1375: WHERE tax_rate_id = c_tax_rate_id;
1376:
1377: CURSOR get_inclusive_flag_from_ptp(
1378: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS