APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_TRX_CONTRACTS

Line 7327: okl_trx_contracts ktrx

7323: SELECT 'Y',
7324: chrb.orig_system_id1,
7325: ktrx.date_transaction_occurred
7326: FROM okc_k_headers_b CHRB,
7327: okl_trx_contracts ktrx
7328: WHERE ktrx.khr_id_new = chrb.id
7329: AND ktrx.tsu_code = 'ENTERED'
7330: AND ktrx.rbr_code is NOT NULL
7331: AND ktrx.tcn_type = 'TRBK'

Line 7555: from okl_trx_contracts tcn,

7551:
7552: --cursor to read whether product change or customer change
7553: cursor l_relk_reason_csr(p_chr_id in number) is
7554: select tcn.rbr_code
7555: from okl_trx_contracts tcn,
7556: okl_trx_types_tl ttl
7557: where ttl.id = tcn.try_id
7558: and ttl.language = 'US'
7559: and ttl.name = 'Release'

Line 7567: l_relk_reason okl_trx_contracts.rbr_code%TYPE;

7563: and tcn.representation_type = 'PRIMARY'
7564: --
7565: and tcn.khr_id = p_chr_id;
7566:
7567: l_relk_reason okl_trx_contracts.rbr_code%TYPE;
7568:
7569: --cursor to read subsidy setup
7570: cursor l_tsfr_basis_csr (p_subsidy_id in number) is
7571: select subb.transfer_basis_code