DBA Data[Home] [Help]

APPS.GL_BC_GROUP_PKG dependencies on DUAL

Line 14: select 1 into dummy from dual

10:
11: PROCEDURE check_unique_bc_option_name(X_bc_option_name VARCHAR2 ) IS
12: dummy NUMBER;
13: BEGIN
14: select 1 into dummy from dual
15: where not exists
16: (select 1 from gl_bc_options
17: where bc_option_name = X_bc_option_name);
18: EXCEPTION

Line 30: FROM dual;

26: next_id NUMBER;
27: BEGIN
28: SELECT gl_bc_options_s.nextval
29: INTO next_id
30: FROM dual;
31:
32: RETURN (next_id);
33: END get_unique_id;
34: