APPS.OKL_BTCH_CASH_APPLIC dependencies on OKL_K_HEADERS_FULL_V

Line 82: SELECT currency_code FROM okl_k_headers_full_v WHERE id = cp_khr_id;

78: AND a.date_effective = trunc(cp_receipt_date);
79:
80: --start code by pgomes on 03/05/2003
81: CURSOR l_khr_curr_csr(cp_khr_id IN NUMBER) IS
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

Line 89: l_temp_currency_code okl_k_headers_full_v.currency_code%TYPE;

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:
91: --end code by pgomes on 03/05/2003
92: CURSOR l_ar_inv_curr_csr(cp_invoice_id IN NUMBER) IS
93: SELECT invoice_currency_code

Line 1037: SELECT currency_code FROM okl_k_headers_full_v WHERE id = cp_khr_id;

1033: ----------
1034:
1035: --start code by pgomes on 03/05/2003
1036: CURSOR l_khr_curr_csr(cp_khr_id IN NUMBER) IS
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

Line 1044: l_temp_currency_code okl_k_headers_full_v.currency_code%TYPE;

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:
1046: --end code by pgomes on 03/05/2003
1047: CURSOR l_ar_inv_curr_csr(cp_invoice_id IN NUMBER) IS
1048: SELECT invoice_currency_code