APPS.OKL_CONVERT_INT_TYPE_WF dependencies on OKC_K_HEADERS_V

Line 133: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

129: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
130: l_msg_data VARCHAR2(2000);
131:
132: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
133: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
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;

Line 158: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)

154: l_conversion_option VARCHAR2(80);
155: l_formula_name VARCHAR2(150);
156:
157:
158: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
159: IS
160: SELECT chrv.contract_number
161: FROM okc_k_headers_v chrv
162: WHERE chrv.id = p_contract_id;

Line 161: FROM okc_k_headers_v chrv

157:
158: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
159: IS
160: SELECT chrv.contract_number
161: FROM okc_k_headers_v chrv
162: WHERE chrv.id = p_contract_id;
163:
164: CURSOR c_fetch_req_details(p_request_id OKL_TRX_REQUESTS.ID%TYPE)
165: IS