Line 181: select id into stmt from fii_currencies_v where id = 'FII_GLOBAL1';
177: stmt VARCHAR2(240);
178:
179: BEGIN
180: 181: select id into stmt from fii_currencies_v where id = 'FII_GLOBAL1'; 182:
183: RETURN stmt;
184:
185: END get_curr;
Line 202: currency FII_CURRENCIES_V.ID%TYPE;
198:
199: FUNCTION get_dbi_params(region_id IN VARCHAR2) RETURN VARCHAR2 IS
200: employee_id NUMBER(10);
201: employee_name VARCHAR2(240); 202: currency FII_CURRENCIES_V.ID%TYPE; 203: qtr_id NUMBER;
204: BEGIN
205: employee_id := fnd_global.employee_id;
206: currency := 'FII_GLOBAL1';