APPS.GCS_HIERARCHIES_PKG dependencies on DUAL

Line 126: FROM dual

122: last_updated_by,
123: last_update_login,
124: creation_date,
125: created_by
126: FROM dual
127: WHERE NOT EXISTS
128: (SELECT 1
129: FROM gcs_hierarchies_b hb
130: WHERE hb.hierarchy_id = insert_row.hierarchy_id);

Line 152: FROM dual

148: last_updated_by,
149: last_update_login,
150: creation_date,
151: created_by
152: FROM dual
153: WHERE NOT EXISTS (SELECT 1
154: FROM gcs_hierarchies_tl htl
155: WHERE htl.hierarchy_id = insert_row.hierarchy_id
156: AND htl.language = userenv('LANG'));

Line 256: FROM dual

252: last_updated_by,
253: last_update_login,
254: creation_date,
255: created_by
256: FROM dual
257: WHERE NOT EXISTS (SELECT 1
258: FROM gcs_hierarchies_tl htl
259: WHERE htl.hierarchy_id = update_row.hierarchy_id
260: AND htl.language = userenv('LANG'));