DBA Data[Home] [Help]

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 1173: FROM okl_trx_types_tl

1169: l_out_tcnv_rec tcnv_rec_type;
1170:
1171: CURSOR try_csr IS
1172: SELECT id
1173: FROM okl_trx_types_tl
1174: WHERE LANGUAGE = 'US'
1175: AND name = 'Service Integration';
1176:
1177: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 1378: FROM okl_trx_types_tl

1374: l_out_tcnv_rec tcnv_rec_type;
1375:
1376: CURSOR try_csr IS
1377: SELECT id
1378: FROM okl_trx_types_tl
1379: WHERE LANGUAGE = 'US'
1380: AND name = 'Principal Paydown';
1381:
1382: CURSOR con_header_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS