APPS.OKL_TRANSACTION_PVT dependencies on OKL_TRX_TYPES_TL

Line 166: FROM okl_trx_types_tl

162: WHERE id = p_chr_id;
163:
164: CURSOR try_csr(p_trx_type VARCHAR2) IS
165: SELECT id
166: FROM okl_trx_types_tl
167: WHERE LANGUAGE = 'US'
168: AND name = DECODE(p_trx_type,'REBOOK','Rebook',
169: 'SPLIT', 'Split Contract',
170: 'Error');

Line 314: okl_trx_types_tl try

310: -- Modified cursor to pick up Rebook and Re-lease Contract transactions
311: CURSOR trx_csr(p_chr_id_new OKC_K_HEADERS_V.ID%TYPE) IS
312: SELECT trx.id, trx.representation_type --sechawla 01-oct-09 8967918 : added representation type
313: FROM okl_trx_contracts trx,
314: okl_trx_types_tl try
315: WHERE trx.khr_id_new = p_chr_id_new
316: AND try.id = trx.try_id
317: AND try.language = 'US'
318: AND try.name in ('Rebook','Release')

Line 1212: FROM okl_trx_types_tl

1208: l_out_tcnv_rec tcnv_rec_type;
1209:
1210: CURSOR try_csr IS
1211: SELECT id
1212: FROM okl_trx_types_tl
1213: WHERE LANGUAGE = 'US'
1214: AND name = 'Service Integration';
1215:
1216: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 1417: FROM okl_trx_types_tl

1413: l_out_tcnv_rec tcnv_rec_type;
1414:
1415: CURSOR try_csr IS
1416: SELECT id
1417: FROM okl_trx_types_tl
1418: WHERE LANGUAGE = 'US'
1419: AND name = 'Principal Paydown';
1420:
1421: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS