APPS.OKL_ST_CODE_CONVERSIONS dependencies on OKL_SIF_FEES

Line 923: OKL_SIF_FEES SFEB,

919: IS
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

Line 949: FROM OKL_SIF_FEES_V FEES,

945:
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;

Line 955: l_balance_method okl_sif_fees.balance_type_code%TYPE;

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:
955: l_balance_method okl_sif_fees.balance_type_code%TYPE;
956:
957: BEGIN
958:
959: OPEN get_bal_meth_csr(p_transaction_number);