[Home] [Help]
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,
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
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
820: OKL_SIF_RET_STRMS RETURN_STREAMS,
821: OKL_SIF_RETS RETURN_HEADER,
822: OKL_STREAM_INTERFACES HEADER,
823: OKL_SIF_LINES LINES,
824: OKL_SIF_FEES FEES
825: WHERE
826: RETURN_HEADER.transaction_number = p_trx_number
827: AND
828: HEADER.transaction_number = p_trx_number
870: OKL_SIF_RET_STRMS RETURN_STREAMS,
871: OKL_SIF_RETS RETURN_HEADER,
872: OKL_STREAM_INTERFACES HEADER,
873: OKL_SIF_LINES LINES,
874: OKL_SIF_FEES FEES
875: WHERE
876: RETURN_HEADER.transaction_number = p_trx_number
877: AND
878: RETURN_HEADER.id = RETURN_STREAMS.sir_id
1006: CURSOR chk_for_subsidy_csr(p_trx_number NUMBER) IS
1007: SELECT
1008: '1'
1009: FROM
1010: OKL_SIF_FEES SFEB,
1011: OKL_STREAM_INTERFACES SIFB
1012: WHERE
1013: SIFB.ID = SFEB.SIF_ID AND
1014: transaction_number = p_trx_number AND
3325: P_SIL_ID NUMBER,
3326: P_LEVEL_INDX_NUM NUMBER)
3327: IS
3328: SELECT TRUNC(DATE_START)
3329: FROM OKL_SIF_FEES
3330: WHERE DESCRIPTION IN('RENT', 'PRINCIPAL_PAYMENT')
3331: AND LEVEL_INDEX_NUMBER = P_LEVEL_INDX_NUM
3332: AND SIL_ID = P_SIL_ID
3333: AND SIF_ID = P_SIF_ID;