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.

APPS.BIL_BI_PIPELINE_F_PKG dependencies on FII_CURRENCY

Line 121: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

117: (
118: SELECT
119: txn_currency,
120: effective_date,
121: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
122: trunc(least(sysdate,effective_date)))) prate,
123: DECODE(g_sec_currency,NULL,NULL,decode(txn_currency,g_sec_currency,1,
124: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate
125: FROM

Line 124: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate

120: effective_date,
121: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
122: trunc(least(sysdate,effective_date)))) prate,
123: DECODE(g_sec_currency,NULL,NULL,decode(txn_currency,g_sec_currency,1,
124: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate
125: FROM
126: (
127: SELECT
128: DISTINCT txn_currency,

Line 2877: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

2873: (
2874: SELECT
2875: txn_currency,
2876: effective_date,
2877: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2878: trunc(least(sysdate,effective_date)))) prate,
2879: DECODE(g_sec_currency,NULL,NULL,decode(txn_currency,g_sec_currency,1,
2880: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate
2881:

Line 2880: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate

2876: effective_date,
2877: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2878: trunc(least(sysdate,effective_date)))) prate,
2879: DECODE(g_sec_currency,NULL,NULL,decode(txn_currency,g_sec_currency,1,
2880: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate
2881:
2882: FROM
2883: (
2884: SELECT

Line 2932: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,

2928: (
2929: SELECT
2930: txn_currency,
2931: effective_date,
2932: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2933: trunc(least(sysdate,effective_date)))) prate,
2934: DECODE(g_sec_currency,NULL,NULL,decode(txn_currency,g_sec_currency,1,
2935: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate
2936:

Line 2935: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate

2931: effective_date,
2932: DECODE(txn_currency,g_prim_currency,1,fii_currency.get_global_rate_primary(txn_currency,
2933: trunc(least(sysdate,effective_date)))) prate,
2934: DECODE(g_sec_currency,NULL,NULL,decode(txn_currency,g_sec_currency,1,
2935: fii_currency.get_global_rate_secondary(txn_currency,trunc(least(sysdate,effective_date))))) srate
2936:
2937: FROM
2938: (
2939: SELECT