APPS.OKL_SEC_INVESTOR_PVT dependencies on OKL_POOLS

Line 859: SELECT pools.transaction_status,pools.id,pools.pol_id FROM OKL_POOL_TRANSACTIONS pools,OKL_POOLS header

855:
856: -- Cursor for getting the status of the open transaction
857: CURSOR l_trans_status_csr(p_ia_id IN NUMBER)
858: IS
859: SELECT pools.transaction_status,pools.id,pools.pol_id FROM OKL_POOL_TRANSACTIONS pools,OKL_POOLS header
860: where pools.transaction_status <> 'COMPLETE'
861: and pools.transaction_type='ADD' and pools.transaction_reason='ADJUSTMENTS'
862: and pools.pol_id=header.id and header.khr_id=p_ia_id ;
863:

Line 1268: OKL_PRODUCTS KLP, OKL_POOLS POL, FND_CURRENCIES_VL FND

1264: POL.TOTAL_PRINCIPAL_AMOUNT,
1265: POL.TOTAL_RECEIVABLE_AMOUNT
1266: FROM
1267: OKC_K_HEADERS_B CHR,OKC_STATUSES_TL STL,OKC_K_HEADERS_TL TL,OKL_K_HEADERS KHR,
1268: OKL_PRODUCTS KLP, OKL_POOLS POL, FND_CURRENCIES_VL FND
1269: WHERE
1270: TL.ID = CHR.ID AND STL.CODE = CHR.STS_CODE AND TL.LANGUAGE = USERENV('LANG')
1271: AND KHR.ID = CHR.ID AND KLP.ID(+) = KHR.PDT_ID
1272: AND CHR.CURRENCY_CODE = FND.CURRENCY_CODE