APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_TRX_CONTRACTS

Line 7152: okl_trx_contracts ktrx

7148: SELECT 'Y',
7149: chrb.orig_system_id1,
7150: ktrx.date_transaction_occurred
7151: FROM okc_k_headers_b CHRB,
7152: okl_trx_contracts ktrx
7153: WHERE ktrx.khr_id_new = chrb.id
7154: AND ktrx.tsu_code = 'ENTERED'
7155: AND ktrx.rbr_code is NOT NULL
7156: AND ktrx.tcn_type = 'TRBK'

Line 7380: from okl_trx_contracts tcn,

7376:
7377: --cursor to read whether product change or customer change
7378: cursor l_relk_reason_csr(p_chr_id in number) is
7379: select tcn.rbr_code
7380: from okl_trx_contracts tcn,
7381: okl_trx_types_tl ttl
7382: where ttl.id = tcn.try_id
7383: and ttl.language = 'US'
7384: and ttl.name = 'Release'

Line 7392: l_relk_reason okl_trx_contracts.rbr_code%TYPE;

7388: and tcn.representation_type = 'PRIMARY'
7389: --
7390: and tcn.khr_id = p_chr_id;
7391:
7392: l_relk_reason okl_trx_contracts.rbr_code%TYPE;
7393:
7394: --cursor to read subsidy setup
7395: cursor l_tsfr_basis_csr (p_subsidy_id in number) is
7396: select subb.transfer_basis_code