APPS.GL_MOVEMERGE_REQUESTS_PKG dependencies on DUAL

Line 27: FROM dual;

23: --
24: FUNCTION get_unique_id RETURN NUMBER IS
25: CURSOR get_new_id IS
26: SELECT gl_movemerge_requests_s.NEXTVAL
27: FROM dual;
28: new_id number;
29: BEGIN
30: OPEN get_new_id;
31: FETCH get_new_id INTO new_id;

Line 59: FROM DUAL

55:
56: PROCEDURE must_have_accounts (mm_id IN NUMBER) IS
57: CURSOR count_rows IS
58: SELECT 1
59: FROM DUAL
60: WHERE EXISTS (SELECT 1
61: FROM gl_movemerge_accounts
62: WHERE movemerge_request_id = mm_id);
63: BEGIN

Line 106: FROM DUAL

102: X_coaid NUMBER,
103: X_name VARCHAR2) IS
104: CURSOR name_count_new_row IS
105: SELECT 1
106: FROM DUAL
107: WHERE EXISTS (SELECT 1
108: FROM gl_movemerge_requests
109: WHERE name = X_name
110: AND chart_of_accounts_id = X_coaid);

Line 114: FROM DUAL

110: AND chart_of_accounts_id = X_coaid);
111:
112: CURSOR name_count_old_row IS
113: SELECT 1
114: FROM DUAL
115: WHERE EXISTS (SELECT 1
116: FROM gl_movemerge_requests r1, gl_movemerge_requests r2
117: WHERE r1.name = X_name
118: AND r1.chart_of_accounts_id = X_coaid