APPS.QA_VALIDATION_API dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 2646: qa_plan_char_action_triggers qpcat

2642: nvl(qpc.decimal_precision, qc.decimal_precision) decimal_precision
2643: FROM qa_chars qc,
2644: qa_plan_chars qpc,
2645: qa_plan_char_actions qpca,
2646: qa_plan_char_action_triggers qpcat
2647: WHERE
2648: qpca.plan_char_action_trigger_id = qpcat.plan_char_action_trigger_id
2649: AND qpca.plan_char_action_id = pca_id
2650: AND qpc.plan_id = qpcat.plan_id

Line 3107: FROM qa_plan_char_action_triggers

3103: CURSOR rule_cursor (p_id NUMBER, c_id NUMBER) IS
3104: SELECT plan_char_action_trigger_id, trigger_sequence, operator,
3105: low_value_other, high_value_other,
3106: low_value_lookup, high_value_lookup
3107: FROM qa_plan_char_action_triggers
3108: WHERE plan_id = p_id
3109: AND char_id = c_id
3110: ORDER BY trigger_sequence, plan_char_action_trigger_id;
3111:

Line 3264: FROM qa_plan_char_action_triggers pcat, qa_plan_char_actions pca

3260: SELECT pcat.plan_char_action_trigger_id, pcat.trigger_sequence, pcat.operator,
3261: pcat.low_value_other, pcat.high_value_other,
3262: pcat.low_value_lookup, pcat.high_value_lookup,
3263: pca.plan_char_action_id, pca.action_id, pca.message
3264: FROM qa_plan_char_action_triggers pcat, qa_plan_char_actions pca
3265: WHERE plan_id = p_id
3266: AND char_id = c_id
3267: AND pca.plan_char_action_trigger_id = pcat.plan_char_action_trigger_id
3268: AND pca.action_id = 2

Line 4489: FROM qa_plan_char_action_triggers qpt, qa_plan_char_actions qpa

4485: action_elements_tab action_elements_tab_Typ ;
4486:
4487: Cursor cur is
4488: SELECT distinct char_id
4489: FROM qa_plan_char_action_triggers qpt, qa_plan_char_actions qpa
4490: WHERE plan_id = p_plan_id AND
4491: qpt.plan_char_action_trigger_id = qpa.plan_char_action_trigger_id AND
4492: operator = 8;
4493: BEGIN