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 113: CURSOR get_numeric_value_csr(c_result_id zx_process_results.result_id%TYPE) IS

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

Line 115: FROM zx_process_results

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