DBA Data[Home] [Help]

APPS.QA_CHAR_INDEXES_PKG dependencies on QA_PLANS

Line 199: FROM qa_plan_chars qpc, qa_plans qp

195: -- plans (i.e., organization_id <> 0)
196: --
197: CURSOR c_most_common(p_char_id NUMBER) IS
198: SELECT qpc.result_column_name
199: FROM qa_plan_chars qpc, qa_plans qp
200: WHERE qpc.plan_id = qp.plan_id AND
201: qpc.char_id = p_char_id AND
202: qp.organization_id <> 0
203: GROUP BY result_column_name

Line 217: FROM qa_plan_chars qpc, qa_plans qp

213: -- parameter, the plans having this are ignored also.
214: --
215: CURSOR c_result_column(p_char_id NUMBER, p_col VARCHAR2) IS
216: SELECT qpc.plan_id, qpc.result_column_name
217: FROM qa_plan_chars qpc, qa_plans qp
218: WHERE qpc.plan_id = qp.plan_id AND
219: qpc.char_id = p_char_id AND
220: qp.organization_id <> 0 AND
221: qpc.result_column_name <> p_col;

Line 229: FROM qa_plan_chars qpc, qa_plans qp

225: -- Cursor for the case when the decode is not to be stripped off
226: --
227: CURSOR c2_result_column(p_char_id NUMBER) IS
228: SELECT qpc.plan_id, qpc.result_column_name
229: FROM qa_plan_chars qpc, qa_plans qp
230: WHERE qpc.plan_id = qp.plan_id AND
231: qpc.char_id = p_char_id AND
232: qp.organization_id <> 0;
233: