APPS.QP_UI_QUERIES_PKG dependencies on QP_UI_QUERY_COLUMNS

Line 168: from qp_ui_query_columns

164: l_record_exist Number;
165: BEGIN
166: select count(*)
167: into l_record_exist
168: from qp_ui_query_columns
169: where query_id = p_query_id
170: and query_column_index_id = p_column_index_id;
171:
172: if l_record_exist > 0 then

Line 176: Select qp_ui_query_columns_s.nextval

172: if l_record_exist > 0 then
173: return;
174: end if;
175:
176: Select qp_ui_query_columns_s.nextval
177: Into l_column_id
178: From dual;
179:
180: INSERT INTO QP_UI_QUERY_COLUMNS

Line 180: INSERT INTO QP_UI_QUERY_COLUMNS

176: Select qp_ui_query_columns_s.nextval
177: Into l_column_id
178: From dual;
179:
180: INSERT INTO QP_UI_QUERY_COLUMNS
181: (
182: COLUMN_ID,
183: QUERY_ID,
184: QUERY_COLUMN_INDEX_ID,