APPS.QA_VALIDATION_API dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 2579: qa_plan_char_action_triggers qpcat

2575: nvl(qpc.decimal_precision, qc.decimal_precision) decimal_precision
2576: FROM qa_chars qc,
2577: qa_plan_chars qpc,
2578: qa_plan_char_actions qpca,
2579: qa_plan_char_action_triggers qpcat
2580: WHERE
2581: qpca.plan_char_action_trigger_id = qpcat.plan_char_action_trigger_id
2582: AND qpca.plan_char_action_id = pca_id
2583: AND qpc.plan_id = qpcat.plan_id

Line 3040: FROM qa_plan_char_action_triggers

3036: CURSOR rule_cursor (p_id NUMBER, c_id NUMBER) IS
3037: SELECT plan_char_action_trigger_id, trigger_sequence, operator,
3038: low_value_other, high_value_other,
3039: low_value_lookup, high_value_lookup
3040: FROM qa_plan_char_action_triggers
3041: WHERE plan_id = p_id
3042: AND char_id = c_id
3043: ORDER BY trigger_sequence, plan_char_action_trigger_id;
3044:

Line 3197: FROM qa_plan_char_action_triggers pcat, qa_plan_char_actions pca

3193: SELECT pcat.plan_char_action_trigger_id, pcat.trigger_sequence, pcat.operator,
3194: pcat.low_value_other, pcat.high_value_other,
3195: pcat.low_value_lookup, pcat.high_value_lookup,
3196: pca.plan_char_action_id, pca.action_id, pca.message
3197: FROM qa_plan_char_action_triggers pcat, qa_plan_char_actions pca
3198: WHERE plan_id = p_id
3199: AND char_id = c_id
3200: AND pca.plan_char_action_trigger_id = pcat.plan_char_action_trigger_id
3201: AND pca.action_id = 2

Line 4306: FROM qa_plan_char_action_triggers qpt, qa_plan_char_actions qpa

4302: action_elements_tab action_elements_tab_Typ ;
4303:
4304: Cursor cur is
4305: SELECT distinct char_id
4306: FROM qa_plan_char_action_triggers qpt, qa_plan_char_actions qpa
4307: WHERE plan_id = p_plan_id AND
4308: qpt.plan_char_action_trigger_id = qpa.plan_char_action_trigger_id AND
4309: operator = 8;
4310: BEGIN