APPS.QA_CHAR_INDEXES_PKG dependencies on QA_PLAN_CHARS

Line 193: FROM qa_plan_chars qpc, qa_plans qp

189: -- plans (i.e., organization_id <> 0)
190: --
191: CURSOR c_most_common(p_char_id NUMBER) IS
192: SELECT qpc.result_column_name
193: FROM qa_plan_chars qpc, qa_plans qp
194: WHERE qpc.plan_id = qp.plan_id AND
195: qpc.char_id = p_char_id AND
196: qp.organization_id <> 0
197: GROUP BY result_column_name

Line 211: FROM qa_plan_chars qpc, qa_plans qp

207: -- parameter, the plans having this are ignored also.
208: --
209: CURSOR c_result_column(p_char_id NUMBER, p_col VARCHAR2) IS
210: SELECT qpc.plan_id, qpc.result_column_name
211: FROM qa_plan_chars qpc, qa_plans qp
212: WHERE qpc.plan_id = qp.plan_id AND
213: qpc.char_id = p_char_id AND
214: qp.organization_id <> 0 AND
215: qpc.result_column_name <> p_col;