DBA Data[Home] [Help]

APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKL_POOL_TRANSACTIONS

Line 1106: OKL_POOL_TRANSACTIONS POX

1102: -- Cursor to fetch the latest of buy back dates on a contract
1103: CURSOR get_max_buy_back_date(p_khr_id OKC_K_HEADERS_B.ID%TYPE, p_sty_code OKL_POOL_CONTENTS.STY_CODE%TYPE) IS
1104: SELECT TRUNC(MAX(POX.DATE_EFFECTIVE))
1105: FROM OKL_POOL_CONTENTS POC,
1106: OKL_POOL_TRANSACTIONS POX
1107: WHERE POC.KHR_ID = p_khr_id
1108: AND POC.STY_CODE = p_sty_code
1109: AND POX.POL_ID = POC.POL_ID
1110: AND POX.TRANSACTION_NUMBER = POC.TRANSACTION_NUMBER_IN