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);
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
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