DBA Data[Home] [Help]

APPS.OKL_CONVERT_INT_TYPE_WF dependencies on OKL_K_RATE_PARAMS_V

Line 138: l_int_details OKL_K_RATE_PARAMS_V%ROWTYPE;

134: l_trx_id NUMBER;
135: l_chrv_id NUMBER;
136: l_request_details OKL_TRX_REQUESTS%ROWTYPE;
137: l_cit_details OKL_CONVERT_INT_RATE_REQUEST_V%ROWTYPE;
138: l_int_details OKL_K_RATE_PARAMS_V%ROWTYPE;
139: l_var_method VARCHAR2(30);
140: l_int_method VARCHAR2(30);
141: l_calc_method VARCHAR2(30);
142: l_adj_freq VARCHAR2(30);

Line 181: FROM OKL_K_RATE_PARAMS_V

177: p_effective_date IN DATE,
178: p_parameter_type_code IN VARCHAR2)
179: IS
180: SELECT *
181: FROM OKL_K_RATE_PARAMS_V
182: WHERE KHR_ID = p_contract_id
183: AND EFFECTIVE_FROM_DATE = p_effective_date
184: AND PARAMETER_TYPE_CODE = p_parameter_type_code;
185: