APPS.OKL_AM_SECURITIZATION_PVT dependencies on OKL_POOL_CONTENTS

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

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
1108: AND POC.STY_CODE = p_sty_code
1109: AND POX.POL_ID = POC.POL_ID

Line 1117: , p_sty_code OKL_POOL_CONTENTS.STY_CODE%TYPE) IS

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
1121: , OKL_POOLS POOL

Line 1120: FROM OKL_POOL_CONTENTS POC

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
1121: , OKL_POOLS POOL
1122: WHERE POOL.ID = POC.POL_ID
1123: AND POC.KHR_ID = p_khr_id
1124: AND POC.KLE_ID = p_kle_id