APPS.QA_PARENT_CHILD_COPY_PKG dependencies on QA_PLAN_CHARS

Line 509: FROM qa_plans qp, qa_plan_chars qpc, qa_plan_char_action_triggers qpcat, qa_plan_char_actions qpca

505:
506: --this cursor selects all actions for a given plan_id
507: CURSOR C1 (p_plan_id NUMBER) IS
508: SELECT qpca.plan_char_action_id, qpca.alr_action_id, qpca.message
509: FROM qa_plans qp, qa_plan_chars qpc, qa_plan_char_action_triggers qpcat, qa_plan_char_actions qpca
510: WHERE qp.plan_id = qpc.plan_id AND qpc.char_id = qpcat.char_id AND qp.plan_id = qpcat.plan_id
511: AND qpcat.plan_char_action_trigger_id = qpca.plan_char_action_trigger_id AND qp.plan_id=p_plan_id;
512: l_message qa_plan_char_actions.message%TYPE;
513:

Line 828: FROM qa_plan_chars qpc,qa_chars qc, qa_char_indexes qci

824: -- srhariha. Tue Nov 30 11:59:20 PST 2004
825:
826: CURSOR qa_pc(p_plan_id NUMBER) IS
827: SELECT qpc.char_id,qpc.result_column_name,qc.name
828: FROM qa_plan_chars qpc,qa_chars qc, qa_char_indexes qci
829: WHERE qpc.plan_id = p_plan_id
830: AND qpc.char_id = qc.char_id
831: AND qpc.char_id = qci.char_id
832: AND qci.enabled_flag = 1;