APPS.CUG_INCIDNT_ATTR_VALS_PVT dependencies on DUAL

Line 100: from dual;

96:
97:
98: select CUG_INCIDNT_ATTR_VALS_B_S.NEXTVAL
99: into p_sr_tbl(i).incidnt_attr_val_id
100: from dual;
101:
102:
103: CUG_INCIDNT_ATTR_VALS_PKG.INSERT_ROW (
104: X_ROWID => l_rowid,

Line 227: SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;

223: FETCH l_servereq_csr INTO l_servereq_csr_rec;
224: -- EXIT WHEN l_servereq_csr%NOTFOUND;
225:
226: -- Construct the unique item key
227: SELECT cs_wf_process_id_s.NEXTVAL INTO l_wf_process_id FROM DUAL;
228: l_itemkey := l_servereq_csr_rec.incident_number || '-' || to_char(l_wf_process_id);
229:
230: -- Update the workflow process ID of the request
231: IF TO_NUMBER(FND_PROFILE.VALUE('USER_ID')) IS NOT NULL THEN