APPS.CZ_CONFIG_API_PUB dependencies on DUAL

Line 54: FROM dual;

50: IF ((last_hdr_allocated IS NULL) OR
51: (next_hdr_to_use = last_hdr_allocated + id_increment)) THEN
52: SELECT cz_config_hdrs_s.NEXTVAL
53: INTO last_hdr_allocated
54: FROM dual;
55: next_hdr_to_use := last_hdr_allocated;
56: END IF;
57:
58: l_config_hdr_id := next_hdr_to_use;

Line 91: FROM dual;

87: IF ((last_item_allocated IS NULL) OR
88: (next_item_to_use = last_item_allocated + id_increment)) THEN
89: SELECT cz_config_items_s.NEXTVAL
90: INTO last_item_allocated
91: FROM dual;
92: next_item_to_use := last_item_allocated;
93: END IF;
94: l_config_item_id := next_item_to_use;
95: next_item_to_use := next_item_to_use + 1;

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

103:
104: BEGIN
105: IF ((last_msg_seq_allocated IS NULL) OR
106: (next_msg_seq_to_use = last_msg_seq_allocated + id_increment)) THEN
107: SELECT cz_config_messages_s.NEXTVAL INTO last_msg_seq_allocated FROM dual;
108: next_msg_seq_to_use := last_msg_seq_allocated;
109: END IF;
110:
111: l_msg_seq := next_msg_seq_to_use;