1736: inc.conv_type RATE_TYPE
1737: , CASE WHEN (UPPER(inc.conv_type) = 'USER' )
1738: THEN inc.rate
1739: ELSE
1740: FII_CURRENCY.Get_Rate(inc.trx_currency
1741: ,inc.func_currency
1742: ,inc.conv_date,inc.conv_type)
1743: END rate_f,
1744: FII_CURRENCY.Get_TC_To_PGC_Rate(inc.trx_currency
1740: FII_CURRENCY.Get_Rate(inc.trx_currency
1741: ,inc.func_currency
1742: ,inc.conv_date,inc.conv_type)
1743: END rate_f,
1744: FII_CURRENCY.Get_TC_To_PGC_Rate(inc.trx_currency
1745: ,inc.conv_date
1746: ,inc.conv_type
1747: ,inc.func_currency
1748: ,inc.conv_date,inc.rate) RATE_G,
1745: ,inc.conv_date
1746: ,inc.conv_type
1747: ,inc.func_currency
1748: ,inc.conv_date,inc.rate) RATE_G,
1749: FII_CURRENCY.Get_TC_To_SGC_Rate(inc.trx_currency
1750: ,inc.conv_date
1751: ,inc.conv_type
1752: ,inc.func_currency
1753: ,inc.conv_date,inc.rate) RATE_SG