APPS.OKL_ST_CODE_CONVERSIONS dependencies on OKL_STREAM_INTERFACES

Line 870: FROM okl_stream_interfaces_v sfe,

866: CURSOR Get_mode_csr(cp_transaction_no NUMBER )
867: IS
868: SELECT
869: sfe.deal_type,sil.sil_type
870: FROM okl_stream_interfaces_v sfe,
871: okl_sif_lines_v sil
872: WHERE transaction_number = cp_transaction_no
873: AND sil.sif_id = sfe.id;
874:

Line 907: OKL_STREAM_INTERFACES SIFB

903: SELECT
904: AMOUNT
905: FROM
906: OKL_SIF_FEES SFEB,
907: OKL_STREAM_INTERFACES SIFB
908: WHERE
909: SFEB.SIF_ID = SIFB.ID AND
910: SFEB.SFE_TYPE = 'SFR' AND
911: SFEB.FEE_INDEX_NUMBER = cp_fee_index AND

Line 933: OKL_STREAM_INTERFACES SIF

929: CURSOR get_bal_meth_csr(p_trx_number IN NUMBER)
930: IS
931: SELECT FEES.BALANCE_TYPE_CODE
932: FROM OKL_SIF_FEES_V FEES,
933: OKL_STREAM_INTERFACES SIF
934: WHERE SIF.TRANSACTION_NUMBER = p_trx_number
935: AND SIF.ID = FEES.SIF_ID
936: AND FEES.BALANCE_TYPE_CODE IS NOT NULL;
937:

Line 1037: FROM OKL_STREAM_INTERFACES

1033: IS
1034: CURSOR get_contract_id_csr(p_trx_number NUMBER)
1035: IS
1036: SELECT KHR_ID
1037: FROM OKL_STREAM_INTERFACES
1038: WHERE TRANSACTION_NUMBER = p_trx_number;
1039:
1040: --This cursor determines whether there have been any Paydowns on this Contract
1041: CURSOR is_ppd_available_csr(chrId NUMBER)