APPS.OKL_PROCESS_STREAMS_PVT dependencies on OKL_SIF_FEES

Line 670: -- select kle_fee_id as well from the OKL_SIF_FEES table

666: RETURN_STREAMS.INDEX_NUMBER ASSET_INDEX_NUMBER,
667: STREAM_TYPE.ID stream_type_id,
668: HEADER.KHR_ID,
669: -- added akjain 06-13-2002
670: -- select kle_fee_id as well from the OKL_SIF_FEES table
671: FEES.KLE_ID KLE_ID
672: -- TO_NUMBER(NULL)
673: FROM
674: OKL_STRM_TYPE_B STREAM_TYPE,

Line 679: OKL_SIF_FEES FEES

675: OKL_SIF_RET_STRMS RETURN_STREAMS,
676: OKL_SIF_RETS RETURN_HEADER,
677: OKL_STREAM_INTERFACES HEADER,
678: -- OKL_SIF_LINES LINES,
679: OKL_SIF_FEES FEES
680: WHERE
681: RETURN_HEADER.transaction_number = p_trx_number
682: AND
683: RETURN_HEADER.id = RETURN_STREAMS.sir_id

Line 733: OKL_SIF_FEES FEES

729: OKL_SIF_RET_STRMS RETURN_STREAMS,
730: OKL_SIF_RETS RETURN_HEADER,
731: OKL_STREAM_INTERFACES HEADER,
732: OKL_SIF_LINES LINES,
733: OKL_SIF_FEES FEES
734: WHERE
735: RETURN_HEADER.transaction_number = p_trx_number
736: AND
737: RETURN_HEADER.id = RETURN_STREAMS.sir_id

Line 821: OKL_SIF_FEES FEES

817: OKL_SIF_RET_STRMS RETURN_STREAMS,
818: OKL_SIF_RETS RETURN_HEADER,
819: OKL_STREAM_INTERFACES HEADER,
820: OKL_SIF_LINES LINES,
821: OKL_SIF_FEES FEES
822: WHERE
823: RETURN_HEADER.transaction_number = p_trx_number
824: AND
825: RETURN_HEADER.id = RETURN_STREAMS.sir_id

Line 957: OKL_SIF_FEES SFEB,

953: CURSOR chk_for_subsidy_csr(p_trx_number NUMBER) IS
954: SELECT
955: '1'
956: FROM
957: OKL_SIF_FEES SFEB,
958: OKL_STREAM_INTERFACES SIFB
959: WHERE
960: SIFB.ID = SFEB.SIF_ID AND
961: transaction_number = p_trx_number AND