82: SELECT currency_code FROM okl_k_headers_full_v WHERE id = cp_khr_id;
83:
84: CURSOR l_inv_curr_csr(cp_consolidated_invoice_id IN NUMBER) IS
85: SELECT currency_code
86: FROM okl_cnsld_ar_hdrs_b
87: WHERE id = cp_consolidated_invoice_id;
88:
89: l_temp_currency_code okl_k_headers_full_v.currency_code%TYPE;
90:
1037: SELECT currency_code FROM okl_k_headers_full_v WHERE id = cp_khr_id;
1038:
1039: CURSOR l_inv_curr_csr(cp_consolidated_invoice_id IN NUMBER) IS
1040: SELECT currency_code
1041: FROM okl_cnsld_ar_hdrs_b
1042: WHERE id = cp_consolidated_invoice_id;
1043:
1044: l_temp_currency_code okl_k_headers_full_v.currency_code%TYPE;
1045: