eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.BIL_BI_FST_DTL_F_PKG dependencies on FII_CURRENCY

Line 1362: fii_currency.get_global_rate_primary(currency_code,trunc(least(sysdate, submission_date)))) prate,

1358: SELECT
1359: currency_code,
1360: submission_date,
1361: DECODE(currency_code,g_prim_currency,1,
1362: fii_currency.get_global_rate_primary(currency_code,trunc(least(sysdate, submission_date)))) prate,
1363: DECODE(g_sec_currency,NULL,NULL,DECODE(currency_code,g_sec_currency,1,
1364: fii_currency.get_global_rate_secondary(currency_code,trunc(least(sysdate, submission_date))))) srate
1365: FROM
1366: (

Line 1364: fii_currency.get_global_rate_secondary(currency_code,trunc(least(sysdate, submission_date))))) srate

1360: submission_date,
1361: DECODE(currency_code,g_prim_currency,1,
1362: fii_currency.get_global_rate_primary(currency_code,trunc(least(sysdate, submission_date)))) prate,
1363: DECODE(g_sec_currency,NULL,NULL,DECODE(currency_code,g_sec_currency,1,
1364: fii_currency.get_global_rate_secondary(currency_code,trunc(least(sysdate, submission_date))))) srate
1365: FROM
1366: (
1367: SELECT /*+ PARALLEL(nfi) */
1368: DISTINCT currency_code currency_code,