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 801: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS

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

Line 849: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS

845: SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
846: and exists(
847: select 1
848: from
849: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
850: where
851: REQUESTED_STREAMS.sil_id = lines.id
852: and REQUESTED_STREAMS.sfe_id is NULL
853: and stream_type.id = REQUESTED_STREAMS.sty_id)

Line 896: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS

892: SYSDATE BETWEEN STREAM_TYPE.START_DATE AND NVL(STREAM_TYPE.END_DATE, SYSDATE)
893: AND EXISTS(
894: SELECT 1
895: FROM
896: OKL_SIF_STREAM_TYPES REQUESTED_STREAMS
897: WHERE
898: REQUESTED_STREAMS.sfe_id = fees.id
899: AND stream_type.id = REQUESTED_STREAMS.sty_id
900: AND HEADER.ID = REQUESTED_STREAMS.sif_id