APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKL_SIF_STREAM_TYPES

Line 708: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS

704: -- Start of Changes
705: AND EXISTS(
706: SELECT 1
707: FROM
708: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
709: WHERE
710: REQUESTED_STREAMS.sfe_id = fees.id
711: AND REQUESTED_STREAMS.sil_id is NULL
712: AND stream_type.id = REQUESTED_STREAMS.sty_id

Line 755: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS

751: AND SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
752: AND EXISTS(
753: SELECT 1
754: FROM
755: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
756: WHERE
757: REQUESTED_STREAMS.sfe_id = fees.id
758: AND stream_type.id = REQUESTED_STREAMS.sty_id
759: AND HEADER.ID = REQUESTED_STREAMS.sif_id

Line 797: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS

793: SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
794: and exists(
795: select 1
796: from
797: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
798: where
799: REQUESTED_STREAMS.sil_id = lines.id
800: and REQUESTED_STREAMS.sfe_id is NULL
801: and stream_type.id = REQUESTED_STREAMS.sty_id)

Line 843: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS

839: SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
840: AND EXISTS(
841: SELECT 1
842: FROM
843: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
844: WHERE
845: REQUESTED_STREAMS.sfe_id = fees.id
846: AND stream_type.id = REQUESTED_STREAMS.sty_id
847: AND HEADER.ID = REQUESTED_STREAMS.sif_id