DBA Data[Home] [Help]

APPS.GCS_CURR_TREATMENTS_PKG dependencies on DUAL

Line 119: FROM dual

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

Line 149: FROM dual

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

Line 273: FROM dual

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