115: CREATION_DATE,
116: CREATED_BY,
117: LAST_UPDATE_LOGIN,
118: OBJECT_VERSION_NUMBER
119: FROM dual
120: WHERE NOT EXISTS
121: (SELECT 1
122: FROM gcs_curr_treatments_b cb
123: WHERE cb.CURR_TREATMENT_ID= insert_row.CURR_TREATMENT_ID);
145: LAST_UPDATE_DATE,
146: LAST_UPDATED_BY,
147: LAST_UPDATE_LOGIN,
148: DESCRIPTION
149: FROM dual
150: WHERE NOT EXISTS
151: (SELECT 1
152: FROM gcs_curr_treatments_tl ctl
153: WHERE ctl.CURR_TREATMENT_ID = insert_row.CURR_TREATMENT_ID
269: CREATION_DATE,
270: CREATED_BY,
271: LAST_UPDATE_LOGIN,
272: DESCRIPTION
273: FROM dual
274: WHERE NOT EXISTS
275: (
276: SELECT 1
277: FROM GCS_CURR_TREATMENTS_TL ctl