60: CREATION_DATE,
61: CREATED_BY,
62: LAST_UPDATE_LOGIN
63:
64: FROM dual
65: WHERE NOT EXISTS
66: (SELECT 1
67: FROM gcs_elim_rule_steps_b cb
68: WHERE cb.RULE_STEP_ID= insert_row.RULE_STEP_ID
90: created_by,
91: LAST_UPDATE_LOGIN,
92: RULE_STEP_ID
93:
94: FROM dual
95: WHERE NOT EXISTS
96: (SELECT 1
97: FROM gcs_elim_rule_steps_tl ctl
98: WHERE ctl.RULE_STEP_ID = insert_row.RULE_STEP_ID
176: CREATION_DATE,
177: CREATED_BY,
178: LAST_UPDATE_LOGIN
179:
180: FROM dual
181: WHERE NOT EXISTS
182: (SELECT 1
183: FROM gcs_elim_rule_steps_tl ctl
184: WHERE ctl.RULE_STEP_ID = update_row.RULE_STEP_ID