APPS.OKL_AM_TERMINATE_INV_AGMT_PVT dependencies on OKL_POOL_TRANSACTIONS

Line 1228: FROM OKL_POOL_TRANSACTIONS POX,

1224: Start Changes*/
1225:
1226: CURSOR get_trans_pox_cont_csr (p_ia_id IN NUMBER) IS
1227: SELECT POX.id
1228: FROM OKL_POOL_TRANSACTIONS POX,
1229: OKL_POOLS POL
1230: WHERE POL.id=POX.pol_id
1231: AND POX.transaction_status <> 'COMPLETE'
1232: AND POL.khr_id =p_ia_id