DBA Data[Home] [Help]

APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_STRM_TYPE_B

Line 2545: ,okl_strm_type_b styb

2541: -- Cursor to check if sty is securitized ">=" effective_date
2542: CURSOR l_okl_sty_csr IS
2543: SELECT 1
2544: FROM okl_pools polb
2545: ,okl_strm_type_b styb
2546: ,okl_pool_contents pocb
2547: WHERE polb.khr_id = p_khr_id
2548: AND pocb.pol_id = polb.id
2549: AND pocb.sty_id = styb.id

Line 3470: ,okl_strm_type_b styb

3466: CURSOR l_okl_sty_csr(p_khr_id NUMBER)
3467: IS
3468: SELECT 1
3469: FROM okl_pools polb
3470: ,okl_strm_type_b styb
3471: ,okl_pool_contents pocb
3472: WHERE polb.khr_id = p_khr_id
3473: AND pocb.pol_id = polb.id
3474: AND pocb.sty_id = styb.id