DBA Data[Home] [Help]

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKL_TRX_TYPES_B

Line 4559: ,okl_trx_types_b tryv

4555: SELECT chrb.orig_system_id1 old_chr_id
4556: ,trxb.date_transaction_occurred date_transaction_occurred
4557: FROM okc_k_headers_b chrb
4558: ,okl_trx_contracts trxb
4559: ,okl_trx_types_b tryv
4560: WHERE chrb.id = p_khr_id
4561: -- AND trxb.khr_id_old = chrb.orig_system_id1
4562: AND trxb.khr_id = chrb.id
4563: AND trxb.tsu_code = 'PROCESSED'

Line 4572: ,okl_trx_types_b tryv

4568: SELECT chrb.orig_system_id1 old_chr_id
4569: ,trxb2.date_transaction_occurred date_transaction_occurred
4570: FROM okc_k_headers_b chrb
4571: ,okl_trx_contracts trxb1
4572: ,okl_trx_types_b tryv
4573: ,okl_trx_contracts trxb2
4574: WHERE chrb.id = p_khr_id
4575: AND trxb1.khr_id = chrb.id
4576: AND trxb1.tsu_code = 'PROCESSED'