APPS.GCS_AD_TRIALBALANCE_PKG dependencies on DUAL

Line 169: || 'FROM dual'

165: 'SELECT gcs_entry_headers_s.NEXTVAL'
166: || g_nl
167: || 'INTO l_entry_id'
168: || g_nl
169: || 'FROM dual'
170: );
171: END IF;
172:
173: SELECT gcs_entry_headers_s.NEXTVAL

Line 175: FROM DUAL;

171: END IF;
172:
173: SELECT gcs_entry_headers_s.NEXTVAL
174: INTO l_entry_id
175: FROM DUAL;
176:
177: gcs_entry_pkg.insert_entry_header
178: (p_entry_id => l_entry_id,
179: p_hierarchy_id => p_hierarchy_id,

Line 224: FROM DUAL

220: -- we simply update this entry
221: BEGIN
222: SELECT 'Y'
223: INTO l_processed_entry_flag
224: FROM DUAL
225: WHERE EXISTS (SELECT run_detail_id
226: FROM gcs_cons_eng_run_dtls gcerd
227: WHERE gcerd.entry_id = l_entry_id);
228: EXCEPTION

Line 305: || 'FROM dual'

301: 'SELECT gcs_entry_headers_s.NEXTVAL'
302: || g_nl
303: || 'INTO l_new_entry_id'
304: || g_nl
305: || 'FROM dual'
306: );
307: END IF;
308:
309: SELECT gcs_entry_headers_s.NEXTVAL

Line 311: FROM DUAL;

307: END IF;
308:
309: SELECT gcs_entry_headers_s.NEXTVAL
310: INTO l_new_entry_id
311: FROM DUAL;
312:
313: IF fnd_log.g_current_runtime_level <= fnd_log.level_statement
314: THEN
315: fnd_log.STRING (fnd_log.level_statement,