APPS.OKL_ST_CODE_CONVERSIONS dependencies on OKL_SIF_FEES

Line 906: OKL_SIF_FEES SFEB,

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

Line 932: FROM OKL_SIF_FEES_V FEES,

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

Line 938: l_balance_method okl_sif_fees.balance_type_code%TYPE;

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:
938: l_balance_method okl_sif_fees.balance_type_code%TYPE;
939:
940: BEGIN
941:
942: OPEN get_bal_meth_csr(p_transaction_number);