APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_TRX_CONTRACTS

Line 4468: okl_trx_contracts ktrx

4464: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
4465: SELECT 'Y' return_value
4466: FROM okc_k_headers_b chrb,
4467: okc_k_headers_b chrb2,
4468: okl_trx_contracts ktrx
4469: WHERE ktrx.khr_id_old = chrb.id
4470: AND ktrx.tsu_code = 'PROCESSED'
4471: AND ktrx.rbr_code IS NOT NULL
4472: AND ktrx.tcn_type = 'TRBK'

Line 4481: AND vpb.source_table = 'OKL_TRX_CONTRACTS'

4477: AND chrb2.orig_system_source_code = 'OKL_REBOOK'
4478: AND chrb2.id = ktrx.khr_id_new
4479: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4480: WHERE vpb.khr_id = chrb.id
4481: AND vpb.source_table = 'OKL_TRX_CONTRACTS'
4482: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4483: AND vpb.source_id = ktrx.id);
4484:
4485: --checks if newly created Daily Interest - Principal stream elements exist

Line 4884: ,'OKL_TRX_CONTRACTS' source_table

4880:
4881: --get the id's of Rebook Transactions
4882: CURSOR l_rebook_csr(cp_khr_id NUMBER) IS
4883: SELECT ktrx.id source_id
4884: ,'OKL_TRX_CONTRACTS' source_table
4885: FROM okc_k_headers_b chrb,
4886: okc_k_headers_b chrb2,
4887: okl_trx_contracts ktrx
4888: WHERE ktrx.khr_id_old = chrb.id

Line 4887: okl_trx_contracts ktrx

4883: SELECT ktrx.id source_id
4884: ,'OKL_TRX_CONTRACTS' source_table
4885: FROM okc_k_headers_b chrb,
4886: okc_k_headers_b chrb2,
4887: okl_trx_contracts ktrx
4888: WHERE ktrx.khr_id_old = chrb.id
4889: AND ktrx.tsu_code = 'PROCESSED'
4890: AND ktrx.rbr_code IS NOT NULL
4891: AND ktrx.tcn_type = 'TRBK'

Line 4900: AND vpb.source_table = 'OKL_TRX_CONTRACTS'

4896: AND chrb2.orig_system_source_code = 'OKL_REBOOK'
4897: AND chrb2.id = ktrx.khr_id_new
4898: AND NOT EXISTS (select 1 FROM OKL_VAR_PRINCIPAL_BAL_TXN vpb
4899: WHERE vpb.khr_id = chrb.id
4900: AND vpb.source_table = 'OKL_TRX_CONTRACTS'
4901: AND vpb.int_cal_process = 'VARIABLE_INTEREST'
4902: AND vpb.source_id = ktrx.id);
4903:
4904: --get the id's of Daily Interest - Principal stream elements