DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_STREAM_TYPES_UV

Line 8105: FROM okl_stream_types_uv STL

8101: WHERE id = p_contract_id;
8102:
8103: CURSOR rvi_stream_csr (p_sty_id number, p_contract_start_date date) IS
8104: SELECT 'Y'
8105: FROM okl_stream_types_uv STL
8106: WHERE STL.id = p_sty_id
8107: AND STL.start_date <= p_contract_start_date
8108: AND (STL.end_date >= p_contract_start_date OR STL.end_date IS NULL);
8109:

Line 23724: FROM okl_stream_types_uv STL

23720: WHERE id = p_contract_id;
23721:
23722: CURSOR passthru_stream_csr (p_sty_id number, p_contract_start_date date) IS
23723: SELECT 'Y'
23724: FROM okl_stream_types_uv STL
23725: WHERE STL.id = p_sty_id
23726: AND STL.start_date <= p_contract_start_date
23727: AND (STL.end_date >= p_contract_start_date OR STL.end_date IS NULL);
23728: