APPS.CS_CIC_ATTRIBUTE_PUB dependencies on DUAL

Line 26: FROM sys.dual;

22: l_note_context_tab_dflt JTF_NOTES_PUB.jtf_note_contexts_tbl_type;
23: BEGIN
24: SELECT SYSDATE
25: INTO l_note_date
26: FROM sys.dual;
27:
28: FND_PROFILE.Get('CS_EXT_ATTR_NOTE_STATUS', l_note_status);
29:
30: IF (p_address_note IS NOT NULL) THEN

Line 342: FROM sys.dual;

338: END IF;
339: -- Set the WHO column values.
340: SELECT SYSDATE
341: INTO l_creation_date
342: FROM sys.dual;
343:
344: l_object_version_number := 1;
345: l_ATTRIBUTE1 := NULL;
346: l_ATTRIBUTE2 := NULL;

Line 403: FROM sys.dual;

399:
400: -- Generate the New Sequence # to store in INCIDNT_ATTR_VAL_ID.
401: SELECT CUG_INCIDNT_ATTR_VALS_B_S.nextval
402: INTO l_incident_attr_val_id
403: FROM sys.dual;
404:
405: --- Create Attributes ---
406: CUG_INCIDNT_ATTR_VALS_PKG.INSERT_ROW( X_ROWID => l_row_id,
407: X_INCIDNT_ATTR_VAL_ID => l_incident_attr_val_id,

Line 556: FROM sys.dual;

552:
553: -- Set the WHO column values.
554: SELECT SYSDATE
555: INTO l_last_update_date
556: FROM sys.dual;
557:
558: l_ATTRIBUTE1 := NULL;
559: l_ATTRIBUTE2 := NULL;
560: l_ATTRIBUTE3 := NULL;