APPS.OKL_VARIABLE_INT_UTIL_PVT dependencies on OKL_TRX_TYPES_TL

Line 2314: FROM okl_trx_types_tl

2310:
2311:
2312: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE ) IS
2313: SELECT id trx_try_id
2314: FROM okl_trx_types_tl
2315: WHERE name = p_transaction_type
2316: AND language = 'US';
2317:
2318: CURSOR chr_csr(p_chr_id NUMBER) IS

Line 2329: CURSOR trx_type_name_csr (p_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS

2325: WHERE khr.id = p_chr_id
2326: AND chr.id = khr.id
2327: AND khr.pdt_id = pdt.id;
2328:
2329: CURSOR trx_type_name_csr (p_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
2330: SELECT name
2331: FROM okl_trx_types_tl try
2332: WHERE id = p_trx_type_id
2333: AND try.language = USERENV('LANG');

Line 2331: FROM okl_trx_types_tl try

2327: AND khr.pdt_id = pdt.id;
2328:
2329: CURSOR trx_type_name_csr (p_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
2330: SELECT name
2331: FROM okl_trx_types_tl try
2332: WHERE id = p_trx_type_id
2333: AND try.language = USERENV('LANG');
2334:
2335: --Cursor to get the Account Derivation Option