DBA Data[Home] [Help]

APPS.GCS_INTERCO_RULES_PKG dependencies on DUAL

Line 109: FROM dual

105: SUS_USER_DIM8_ID,
106: SUS_USER_DIM9_ID,
107: SUS_USER_DIM10_ID
108:
109: FROM dual
110: WHERE NOT EXISTS
111: (SELECT 1
112: FROM gcs_interco_rules_b cb
113: WHERE cb.RULE_ID= insert_row.RULE_ID);

Line 142: FROM dual

138: last_updated_by,
139: last_update_login,
140: description
141:
142: FROM dual
143: WHERE NOT EXISTS
144: (SELECT 1
145: FROM gcs_interco_rules_tl ctl
146: WHERE ctl.RULE_ID = insert_row.RULE_ID

Line 263: FROM dual

259: LAST_UPDATE_LOGIN,
260: DESCRIPTION,
261: OBJECT_VERSION_NUMBER
262:
263: FROM dual
264: WHERE NOT EXISTS
265: (SELECT 1
266: FROM gcs_interco_rules_tl ctl
267: WHERE ctl.RULE_ID = update_row.RULE_ID