DBA Data[Home] [Help]

APPS.OKL_STREAMS_UTIL dependencies on OKL_STRM_TMPT_FULL_UV

Line 1726: FROM OKL_STRM_TMPT_FULL_UV STL

1722: WHERE id = l_khr_id;
1723:
1724: CURSOR sty_csr (l_product_id NUMBER, l_contract_start_date DATE) IS
1725: SELECT '1'
1726: FROM OKL_STRM_TMPT_FULL_UV STL
1727: WHERE STL.PDT_ID = l_product_id
1728: AND (STL.START_DATE <= l_contract_start_date)
1729: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
1730: AND STY_ID = p_sty_id;