DBA Data[Home] [Help]

APPS.FII_PMV_UTIL dependencies on FII_CURRENCIES_V

Line 49: --select id into stmt from fii_currencies_v where id = 'FII_GLOBAL1';

45: FUNCTION get_curr RETURN VARCHAR2 IS
46: stmt VARCHAR2(20);
47: BEGIN
48: --fix for repository bug 4945663
49: --select id into stmt from fii_currencies_v where id = 'FII_GLOBAL1';
50: stmt := 'FII_GLOBAL1';
51: RETURN stmt;
52: END get_curr;
53:

Line 66: currency FII_CURRENCIES_V.ID%TYPE;

62:
63: FUNCTION get_dbi_params(region_id IN VARCHAR2) RETURN VARCHAR2 IS
64: employee_id NUMBER(10);
65: employee_name VARCHAR2(240);
66: currency FII_CURRENCIES_V.ID%TYPE;
67: period_id NUMBER;
68: BEGIN
69: employee_id := fnd_global.employee_id;
70: --fix for repository bug 4945663

Line 71: --select id into currency from fii_currencies_v where id = 'FII_GLOBAL1';

67: period_id NUMBER;
68: BEGIN
69: employee_id := fnd_global.employee_id;
70: --fix for repository bug 4945663
71: --select id into currency from fii_currencies_v where id = 'FII_GLOBAL1';
72: currency := 'FII_GLOBAL1';
73: select ENT_PERIOD_ID into period_id from fii_time_ent_period where sysdate
74: between START_DATE and END_DATE;
75: IF (region_id = 'FII_PMV_MGR_PARAMETER_PORTLET') THEN