APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG dependencies on ZX_RATES_B

Line 49: l_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE;

45: l_sum_basiscoef NUMBER;
46: l_sum_basiscoef_qua NUMBER;
47: l_sum_constcoef NUMBER;
48: l_tax_id NUMBER;
49: l_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE;
50: l_compounding_tax_id NUMBER;
51: l_zx_result_rec ZX_PROCESS_RESULTS%ROWTYPE;
52: l_perc_discount NUMBER;
53: l_common_comp_base NUMBER;

Line 71: l_adj_for_adhoc_amt_code ZX_RATES_B.ADJ_FOR_ADHOC_AMT_CODE%TYPE;

67: l_insurance_charge_appl_flag ZX_FORMULA_B.INSURANCE_CHARGE_APPL_FLAG%TYPE;
68: l_other_charge_appl_flag ZX_FORMULA_B.OTHER_CHARGE_APPL_FLAG%TYPE;
69: l_enforce_compounding_flag ZX_FORMULA_DETAILS.ENFORCE_COMPOUNDING_FLAG%TYPE;
70: l_allow_adhoc_tax_rate_flag VARCHAR2(1);
71: l_adj_for_adhoc_amt_code ZX_RATES_B.ADJ_FOR_ADHOC_AMT_CODE%TYPE;
72: l_tax_determine_date DATE;
73: l_tax_rec ZX_TDS_UTILITIES_PKG.ZX_TAX_INFO_CACHE_REC;
74: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.ZX_RATE_INFO_REC_TYPE;
75:

Line 136: FROM ZX_RATES_B

132:
133: CURSOR getAdhocInfo (c_tax_rate_id IN NUMBER) IS
134: SELECT NVL(ADJ_FOR_ADHOC_AMT_CODE,'TAXABLE_BASIS'),
135: NVL(ALLOW_ADHOC_TAX_RATE_FLAG, 'N')
136: FROM ZX_RATES_B
137: WHERE TAX_RATE_ID = c_tax_rate_id;
138:
139: CURSOR get_formula_code_from_rate_csr(
140: c_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE) IS

Line 140: c_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE) IS

136: FROM ZX_RATES_B
137: WHERE TAX_RATE_ID = c_tax_rate_id;
138:
139: CURSOR get_formula_code_from_rate_csr(
140: c_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE) IS
141: SELECT taxable_basis_formula_code
142: FROM zx_rates_b
143: WHERE tax_rate_id = c_tax_rate_id;
144:

Line 142: FROM zx_rates_b

138:
139: CURSOR get_formula_code_from_rate_csr(
140: c_tax_rate_id ZX_RATES_B.TAX_RATE_ID%TYPE) IS
141: SELECT taxable_basis_formula_code
142: FROM zx_rates_b
143: WHERE tax_rate_id = c_tax_rate_id;
144:
145: BEGIN
146: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 1599: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS

1595: l_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1596: l_site_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE;
1597:
1598: CURSOR get_inclusive_flag_from_rate(
1599: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
1600: SELECT inclusive_tax_flag
1601: FROM zx_rates_b
1602: WHERE tax_rate_id = c_tax_rate_id;
1603:

Line 1601: FROM zx_rates_b

1597:
1598: CURSOR get_inclusive_flag_from_rate(
1599: c_tax_rate_id zx_rates_b.tax_rate_id%TYPE) IS
1600: SELECT inclusive_tax_flag
1601: FROM zx_rates_b
1602: WHERE tax_rate_id = c_tax_rate_id;
1603:
1604: CURSOR get_inclusive_flag_from_ptp(
1605: c_ptp_id zx_party_tax_profile.party_tax_profile_id%TYPE) IS