DBA Data[Home] [Help]

APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_STREAM_TYPES_UV

Line 8273: FROM okl_stream_types_uv STL

8269: WHERE id = p_contract_id;
8270:
8271: CURSOR rvi_stream_csr (p_sty_id number, p_contract_start_date date) IS
8272: SELECT 'Y'
8273: FROM okl_stream_types_uv STL
8274: WHERE STL.id = p_sty_id
8275: AND STL.start_date <= p_contract_start_date
8276: AND (STL.end_date >= p_contract_start_date OR STL.end_date IS NULL);
8277:

Line 23913: FROM okl_stream_types_uv STL

23909: WHERE id = p_contract_id;
23910:
23911: CURSOR passthru_stream_csr (p_sty_id number, p_contract_start_date date) IS
23912: SELECT 'Y'
23913: FROM okl_stream_types_uv STL
23914: WHERE STL.id = p_sty_id
23915: AND STL.start_date <= p_contract_start_date
23916: AND (STL.end_date >= p_contract_start_date OR STL.end_date IS NULL);
23917: