APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKC_K_HEADERS_B

Line 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

1099: AND QLT_CODE IN ('AMCFIA');
1100:
1101: -- Bug# 7009075 - Added - Start
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

Line 1115: CURSOR get_active_poc(p_khr_id OKC_K_HEADERS_B.ID%TYPE

1111: AND POX.TRANSACTION_REASON = 'BUY_BACK';
1112:
1113: -- Cursor to fetch the active pool contents for a contract line. Cursor
1114: -- fetches the pool content that is latest first
1115: CURSOR get_active_poc(p_khr_id OKC_K_HEADERS_B.ID%TYPE
1116: , p_kle_id OKC_K_LINES_B.ID%TYPE
1117: , p_sty_code OKL_POOL_CONTENTS.STY_CODE%TYPE) IS
1118: SELECT POOL.KHR_ID IA_ID
1119: , POC.STREAMS_TO_DATE

Line 1202: l_temp_ia_id OKC_K_HEADERS_B.ID%TYPE;

1198: -- Bug# 7009075 - Added
1199: l_max_buy_back_date DATE;
1200: l_stream_to_date DATE;
1201: l_create_inv_khr_oblig BOOLEAN DEFAULT FALSE;
1202: l_temp_ia_id OKC_K_HEADERS_B.ID%TYPE;
1203:
1204: BEGIN
1205:
1206: --message logging