SELECT DECODE(PCSO.INFO_FEE_FLAG,
              'N',
              MIN((NVL(FT.TIER_FEE_FIXED_AMT, 0) +
                  ((NVL(PCSO.FIXED_FACE_AMT, FT.TIER_RNG_BEG_AMT) *
                  NVL(FT.TIER_FEE_PCT, 0)) / 100))),
              NULL) MIN_FEE_FIXED_AMT,
       DECODE(PCSO.INFO_FEE_FLAG, 'N', COUNT(FT.TIER_RNG_BEG_AMT), NULL) CNT_RANGE_BEGIN_AMT,
       DECODE(PCSO.INFO_FEE_FLAG, 'N', MAX(FT.TIER_FEE_PCT), NULL) MAX_FEE_PERCENTAGE,
       PCSO.INFO_FEE_FLAG INFO_FEE_FLAG,
       DECODE(PCSO.INFO_FEE_FLAG, 'Y', PCFL.MIN_FEE_AMT, NULL) INFO_FEE_MIN_AMT,
       DECODE(PCSO.INFO_FEE_FLAG, 'Y', PCFL.MAX_FEE_AMT, NULL) INFO_FEE_MAX_AMT,
       PCSO.FIXED_FACE_AMT FIXED_FACE_AMT,
       CM.CURRENCY_DECIMAL_PRECISION CURRENCY_PRECISION,
       DECODE(MIN(DECODE(FT.TIER_FEE_PCT, NULL, FT.TIER_FEE_FIXED_AMT, NULL)),
              0,
              'Y',
              'N') ZERO_FEE_IND
  FROM PRCG_ENDPT_GROUP_AGENT_B SEGA,
       PRCG_ENDPT_GROUP_AGENT_B REGA,
       PRCG_CORRIDOR_SVC_OPTN_B PCSO,
       PRCG_FEE_TABLE_B         FT,
       PRCG_CNSMR_FEE_LIMIT_B   PCFL,
       CURRENCY_MASTER          CM
 WHERE SEGA.AGENT_ID = :B6
   AND REGA.AGENT_ID = :B3
   AND SEGA.CORRIDOR_ENDPT_GRP_ID = PCSO.SND_ENDPT_GRP_ID
   AND REGA.CORRIDOR_ENDPT_GRP_ID = PCSO.RCV_ENDPT_GRP_ID
   AND CM.ISO_CURRENCY_CODE = :B1
   AND PCSO.PRODUCT_ID = :B2
   AND PCSO.SVC_OFFR_ID = :B5
   AND PCSO.FEE_TYPE_CODE = 'CONSUMER'
   AND PCSO.SND_CURRENCY_ISO_CODE = :B1
   AND PCSO.RCV_CURRENCY_ISO_CODE = :B4
   AND PCSO.FEE_TABLE_ID = FT.FEE_TABLE_ID(+)
   AND :B3 = PCFL.RCV_AGENT_ID(+)
   AND :B2 = PCFL.PRODUCT_ID(+)
   AND :B1 = PCFL.ISO_CURRENCY_CODE(+)
   AND SEGA.ISO_CNTRY_CODE = PCFL.SND_ISO_CNTRY_CODE(+)
   AND SEGA.STATEPROVINCE_ID = PCFL.SND_STATEPROVINCE_ID(+)
   AND (PCSO.FIXED_FACE_AMT IS NULL OR PCSO.FEE_TABLE_ID IS NULL OR
       (PCSO.FIXED_FACE_AMT <= FT.TIER_RNG_END_AMT AND
       PCSO.FIXED_FACE_AMT >= FT.TIER_RNG_BEG_AMT))
 GROUP BY PCSO.SEARCH_PRIORITY,
          PCSO.CORRIDOR_ID,
          PCSO.CORRIDOR_TYPE_CODE,
          PCSO.CORRIDOR_TYPE_DESC,
          PCSO.SND_CURRENCY_ISO_CODE,
          PCSO.RCV_CURRENCY_ISO_CODE,
          PCSO.SVC_OFFR_ID,
          DECODE(PCSO.INFO_FEE_FLAG, 'N', FT.FEE_TABLE_ID, NULL),
          PCSO.INFO_FEE_FLAG,
          DECODE(PCSO.INFO_FEE_FLAG, 'Y', PCFL.MIN_FEE_AMT, NULL),
          DECODE(PCSO.INFO_FEE_FLAG, 'Y', PCFL.MAX_FEE_AMT, NULL),
          PCSO.FIXED_FACE_AMT,
          CM.CURRENCY_DECIMAL_PRECISION
 ORDER BY SEARCH_PRIORITY ASC