DBA Data[Home] [Help]

APPS.OKL_SEC_AGREEMENT_PVT dependencies on OKL_STRM_TYPE_B

Line 2562: ,okl_strm_type_b styb

2558: -- Cursor to check if sty is securitized ">=" effective_date
2559: CURSOR l_okl_sty_csr IS
2560: SELECT 1
2561: FROM okl_pools polb
2562: ,okl_strm_type_b styb
2563: ,okl_pool_contents pocb
2564: WHERE polb.khr_id = p_khr_id
2565: AND pocb.pol_id = polb.id
2566: AND pocb.sty_id = styb.id

Line 3487: ,okl_strm_type_b styb

3483: CURSOR l_okl_sty_csr(p_khr_id NUMBER)
3484: IS
3485: SELECT 1
3486: FROM okl_pools polb
3487: ,okl_strm_type_b styb
3488: ,okl_pool_contents pocb
3489: WHERE polb.khr_id = p_khr_id
3490: AND pocb.pol_id = polb.id
3491: AND pocb.sty_id = styb.id