DBA Data[Home] [Help]

APPS.QA_PARENT_CHILD_COPY_PKG dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

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: