APPS.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on OKL_POOL_TRANSACTIONS
Line 1250: FROM OKL_POOL_TRANSACTIONS POX,
1246: Start Changes*/
1247:
1248: CURSOR get_trans_pox_cont_csr (p_ia_id IN NUMBER) IS
1249: SELECT POX.id 1250: FROM OKL_POOL_TRANSACTIONS POX, 1251: OKL_POOLS POL
1252: WHERE POL.id=POX.pol_id
1253: AND POX.transaction_status <> 'COMPLETE'
1254: AND POL.khr_id =p_ia_id