APPS.OKL_ST_CODE_CONVERSIONS dependencies on OKL_STREAM_INTERFACES

Line 887: FROM okl_stream_interfaces_v sfe,

883: CURSOR Get_mode_csr(cp_transaction_no NUMBER )
884: IS
885: SELECT
886: sfe.deal_type,sil.sil_type
887: FROM okl_stream_interfaces_v sfe,
888: okl_sif_lines_v sil
889: WHERE transaction_number = cp_transaction_no
890: AND sil.sif_id = sfe.id;
891:

Line 924: OKL_STREAM_INTERFACES SIFB

920: SELECT
921: AMOUNT
922: FROM
923: OKL_SIF_FEES SFEB,
924: OKL_STREAM_INTERFACES SIFB
925: WHERE
926: SFEB.SIF_ID = SIFB.ID AND
927: SFEB.SFE_TYPE = 'SFR' AND
928: SFEB.FEE_INDEX_NUMBER = cp_fee_index AND

Line 950: OKL_STREAM_INTERFACES SIF

946: CURSOR get_bal_meth_csr(p_trx_number IN NUMBER)
947: IS
948: SELECT FEES.BALANCE_TYPE_CODE
949: FROM OKL_SIF_FEES_V FEES,
950: OKL_STREAM_INTERFACES SIF
951: WHERE SIF.TRANSACTION_NUMBER = p_trx_number
952: AND SIF.ID = FEES.SIF_ID
953: AND FEES.BALANCE_TYPE_CODE IS NOT NULL;
954:

Line 1054: FROM OKL_STREAM_INTERFACES

1050: IS
1051: CURSOR get_contract_id_csr(p_trx_number NUMBER)
1052: IS
1053: SELECT KHR_ID
1054: FROM OKL_STREAM_INTERFACES
1055: WHERE TRANSACTION_NUMBER = p_trx_number;
1056:
1057: --This cursor determines whether there have been any Paydowns on this Contract
1058: CURSOR is_ppd_available_csr(chrId NUMBER)