DBA Data[Home] [Help]

APPS.OKL_LA_JE_PVT dependencies on OKL_K_HEADERS_FULL_V

Line 210: FROM okl_k_headers_full_v khr

206: ,khr.khr_attribute12
207: ,khr.khr_attribute13
208: ,khr.khr_attribute14
209: ,khr.khr_attribute15
210: FROM okl_k_headers_full_v khr
211: WHERE khr.id = p_contract_id;
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

Line 213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

209: ,khr.khr_attribute15
210: FROM okl_k_headers_full_v khr
211: WHERE khr.id = p_contract_id;
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

Line 214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;

210: FROM okl_k_headers_full_v khr
211: WHERE khr.id = p_contract_id;
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
218:

Line 215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;

211: WHERE khr.id = p_contract_id;
212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
218:
219: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS

Line 216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;

212:
213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
218:
219: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
220: SELECT id trx_try_id

Line 217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;

213: l_func_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
214: l_chr_curr_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE;
215: x_currency_conversion_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
216: x_currency_conversion_type okl_k_headers_full_v.currency_conversion_type%TYPE;
217: x_currency_conversion_date okl_k_headers_full_v.currency_conversion_date%TYPE;
218:
219: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
220: SELECT id trx_try_id
221: FROM okl_trx_types_tl