DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKL_TRX_CONTRACTS

Line 974: ,okl_trx_contracts ktrx

970:
971: CURSOR l_chk_rbk_csr IS
972: SELECT ktrx.date_transaction_occurred
973: FROM okc_k_headers_b chr
974: ,okl_trx_contracts ktrx
975: WHERE ktrx.khr_id_new = chr.id
976: AND ktrx.tsu_code = 'ENTERED'
977: AND ktrx.rbr_code IS NOT NULL
978: AND ktrx.tcn_type = 'TRBK'

Line 1264: ,okl_trx_contracts trx

1260:
1261: CURSOR c_split_info_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
1262: SELECT khr.id, khr.contract_number, khr.start_date, trx.date_transaction_occurred
1263: FROM okc_k_headers_b khr
1264: ,okl_trx_contracts trx
1265: WHERE trx.khr_id = khr.id
1266: AND trx.tsu_code = 'PROCESSED'
1267: AND trx.tcn_type = 'SPLC'
1268: --rkuttiya added for 12.1.1 Multi GAAP