APPS.ZX_TDS_RATE_DETM_PKG dependencies on ZX_PROCESS_RESULTS

Line 66: l_zx_result_rec zx_process_results%ROWTYPE;

62: l_quantity_rate zx_rates_b.quantity_rate%TYPE;
63: l_def_quantity_rate zx_rates_b.quantity_rate%TYPE;
64: l_tax_rate_code zx_rates_b.tax_rate_code%TYPE;
65: l_tax_date date;
66: l_zx_result_rec zx_process_results%ROWTYPE;
67: l_status_index NUMBER;
68: l_effective_from DATE;
69: l_effective_to DATE;
70: l_adhoc_tax_rate_flg VARCHAR2(1);

Line 78: l_numeric_result zx_process_results.numeric_result%TYPE;

74: l_offset_tax zx_rates_b.offset_tax%TYPE;
75: l_offset_tax_appl VARCHAR2(1);
76: l_ptp_id NUMBER;
77: l_reg_party_type VARCHAR2(80);
78: l_numeric_result zx_process_results.numeric_result%TYPE;
79:
80: l_tax_rate_rec ZX_TDS_UTILITIES_PKG.zx_rate_info_rec_type;
81: l_exemption_rec ZX_TCM_GET_EXEMPT_PKG.exemption_rec_type;
82: l_exception_rec ZX_TCM_GET_EXCEPT_PKG.exception_rec_type;

Line 110: CURSOR get_numeric_value_csr(c_result_id zx_process_results.result_id%TYPE) IS

106: SELECT Allow_Offset_Tax_Flag
107: FROM zx_party_tax_profile
108: WHERE party_tax_profile_id = c_ptp_id;
109:
110: CURSOR get_numeric_value_csr(c_result_id zx_process_results.result_id%TYPE) IS
111: SELECT numeric_result
112: FROM zx_process_results
113: WHERE result_id = c_result_id;
114:

Line 112: FROM zx_process_results

108: WHERE party_tax_profile_id = c_ptp_id;
109:
110: CURSOR get_numeric_value_csr(c_result_id zx_process_results.result_id%TYPE) IS
111: SELECT numeric_result
112: FROM zx_process_results
113: WHERE result_id = c_result_id;
114:
115: -- bug 7208618
116: --