APPS.GLXRVSUB_PKG dependencies on GL_REVALUATIONS

Line 9: SELECT gl_revaluations_s.NEXTVAL

5:
6: FUNCTION get_unique_id
7: RETURN NUMBER IS
8: CURSOR get_new_id IS
9: SELECT gl_revaluations_s.NEXTVAL
10: FROM DUAL;
11:
12: new_id NUMBER;
13: BEGIN

Line 23: fnd_message.set_token('SEQUENCE', 'GL_REVALUATIONS_S');

19: RETURN (new_id);
20: ELSE
21: CLOSE get_new_id;
22: fnd_message.set_name('SQLGL', 'GL_ERROR_GETTING_UNIQUE_ID');
23: fnd_message.set_token('SEQUENCE', 'GL_REVALUATIONS_S');
24: app_exception.raise_exception;
25: END IF;
26:
27: EXCEPTION

Line 406: FROM gl_revaluations

402: dummy VARCHAR2(100);
403:
404: CURSOR checkname(revaluation_name VARCHAR2, r_id NUMBER, c_id NUMBER) IS
405: SELECT NAME
406: FROM gl_revaluations
407: WHERE name = revaluation_name
408: AND chart_of_accounts_id = c_id
409: AND revaluation_id <> r_id;
410: BEGIN