266: l_plan_ids,
267: l_result_columns
268: FROM qa_chars qc,
269: qa_plan_chars qpc,
270: qa_plans qp
271: WHERE qc.hardcoded_column IS NULL
272: AND qc.char_id = qpc.char_id
273: AND qpc.char_id = p_char_id
274: AND qpc.plan_id = qp.plan_id
577: AND criteria_id IN
578: (
579: SELECT qch.criteria_id
580: FROM QA_CRITERIA_HEADERS qch,
581: QA_PLANS qp,
582: QA_PLAN_CHARS qpc
583: WHERE qch.organization_id = qp.organization_id
584: AND qp.plan_id = qpc.plan_id
585: AND qpc.char_id = p_char_id
601: AND criteria_id IN
602: (
603: SELECT qch.criteria_id
604: FROM QA_CRITERIA_HEADERS qch,
605: QA_PLANS qp,
606: QA_PLAN_CHARS qpc
607: WHERE qch.organization_id = qp.organization_id
608: AND qp.plan_id = qpc.plan_id
609: AND qpc.char_id = p_char_id
721:
722: CURSOR plan_cur IS
723: SELECT 'Y'
724: FROM QA_PLAN_CHARS qpc,
725: QA_PLANS qp
726: WHERE qpc.char_id = p_char_id
727: AND qpc.plan_id = qp.plan_id
728: AND qp.organization_id <> 0;
729: