APPS.GL_FLATTEN_SEG_VAL_HIERARCHIES dependencies on DUAL

Line 181: FROM DUAL

177: -- used by any chart of accounts or it has an hierarchy.
178:
179: SELECT 1
180: INTO t_record_check_id
181: FROM DUAL
182: WHERE EXISTS
183: (SELECT 1
184: FROM FND_ID_FLEX_SEGMENTS fifs
185: WHERE fifs.application_id = 101

Line 519: DUAL

515: -- procedure.
516:
517: SELECT count(*) INTO l_no_rows
518: FROM
519: DUAL
520: WHERE EXISTS
521: (SELECT 1
522: FROM GL_SEG_VAL_HIERARCHIES
523: WHERE status_code = 'I'