DBA Data[Home] [Help]

APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKC_K_LINES_B

Line 1068: FROM OKC_K_LINES_B

1064: WHERE ID = c_quote_id;
1065:
1066: CURSOR get_rv_khr_id_csr(c_kle_id NUMBER) IS
1067: SELECT CHR_ID
1068: FROM OKC_K_LINES_B
1069: WHERE ID = c_kle_id;
1070:
1071: CURSOR get_qte_asset_details_csr(c_quote_id NUMBER) IS
1072: SELECT KLE_ID, -- STY_ID,

Line 1116: , p_kle_id OKC_K_LINES_B.ID%TYPE

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
1120: FROM OKL_POOL_CONTENTS POC