APPS.CZ_CONFIG_API_PVT dependencies on DUAL

Line 71: FROM dual;

67: IF ((last_hdr_allocated IS NULL) OR
68: (next_hdr_to_use = last_hdr_allocated + id_increment)) THEN
69: SELECT cz_config_hdrs_s.NEXTVAL
70: INTO last_hdr_allocated
71: FROM dual;
72: next_hdr_to_use := last_hdr_allocated;
73: END IF;
74:
75: l_config_hdr_id := next_hdr_to_use;

Line 108: FROM dual;

104: IF ((last_item_allocated IS NULL) OR
105: (next_item_to_use = last_item_allocated + id_increment)) THEN
106: SELECT cz_config_items_s.NEXTVAL
107: INTO last_item_allocated
108: FROM dual;
109: next_item_to_use := last_item_allocated;
110: END IF;
111: l_config_item_id := next_item_to_use;
112: next_item_to_use := next_item_to_use + 1;

Line 124: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;

120:
121: BEGIN
122: IF ((last_msg_seq_allocated IS NULL) OR
123: (next_msg_seq_to_use = last_msg_seq_allocated + id_increment)) THEN
124: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;
125: next_msg_seq_to_use := last_msg_seq_allocated;
126: END IF;
127:
128: l_msg_seq := next_msg_seq_to_use;