DBA Data[Home] [Help]

APPS.GCS_TREATMENTS_PKG dependencies on DUAL

Line 66: FROM dual

62: OWNERSHIP_PERCENT_LOW,
63: OWNERSHIP_PERCENT_HIGH,
64: OBJECT_VERSION_NUMBER
65:
66: FROM dual
67: WHERE NOT EXISTS
68: (SELECT 1
69: FROM gcs_treatments_b cb
70: WHERE cb.TREATMENT_ID= insert_row.TREATMENT_ID);

Line 97: FROM dual

93: created_by,
94: last_update_login,
95: description
96:
97: FROM dual
98: WHERE NOT EXISTS
99: (SELECT 1
100: FROM gcs_treatments_tl ctl
101: WHERE ctl.TREATMENT_ID = insert_row.TREATMENT_ID

Line 187: FROM dual

183: created_by,
184: last_update_login,
185: description
186:
187: FROM dual
188: WHERE NOT EXISTS
189: (SELECT 1
190: FROM GCS_TREATMENTS_TL ctl
191: WHERE ctl.TREATMENT_ID = update_row.TREATMENT_ID