APPS.OKL_ASSET_SUBSIDY_PVT dependencies on OKL_TRX_CONTRACTS

Line 499: FROM okl_trx_contracts ktrx

495:
496: --Cursor to find out Rebook date
497: Cursor l_rbk_date_csr (rbk_chr_id IN NUMBER) is
498: SELECT DATE_TRANSACTION_OCCURRED
499: FROM okl_trx_contracts ktrx
500: WHERE ktrx.KHR_ID_NEW = rbk_chr_id
501: AND ktrx.tsu_code = 'ENTERED'
502: AND ktrx.tcn_type = 'TRBK'
503: --rkuttiya added for 12.1.1 Multi GAAP Project

Line 507: l_rbk_date okl_trx_contracts.DATE_TRANSACTION_OCCURRED%TYPE;

503: --rkuttiya added for 12.1.1 Multi GAAP Project
504: AND ktrx.representation_type = 'PRIMARY';
505: --
506:
507: l_rbk_date okl_trx_contracts.DATE_TRANSACTION_OCCURRED%TYPE;
508:
509: l_rbk_cpy varchar2(1) default 'N';
510:
511:

Line 1369: okl_trx_contracts ktrx

1365: cursor l_chr_rebook (p_asset_cle_id in number) is
1366: Select 'Y'
1367: from okc_k_headers_b chrb,
1368: okc_k_lines_b cleb,
1369: okl_trx_contracts ktrx
1370: where chrb.id = cleb.chr_id
1371: and chrb.id = cleb.dnz_chr_id
1372: and chrb.orig_system_source_code = 'OKL_REBOOK'
1373: and cleb.id = p_asset_cle_id

Line 1389: okl_trx_contracts ktrx

1385: cursor l_chr_mass_rebook (p_asset_cle_id in number) is
1386: Select 'Y'
1387: from okc_k_headers_b chrb,
1388: okc_k_lines_b cleb,
1389: okl_trx_contracts ktrx
1390: where chrb.id = cleb.chr_id
1391: and chrb.id = cleb.dnz_chr_id
1392: and cleb.id = p_asset_cle_id
1393: and ktrx.KHR_ID = chrb.id