DBA Data[Home] [Help]

APPS.QA_CHAR_UPDATE_PKG dependencies on QA_PLANS

Line 270: qa_plans qp

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

Line 581: QA_PLANS qp,

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

Line 605: QA_PLANS qp,

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

Line 725: QA_PLANS qp

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: