APPS.QA_VALIDATION_API dependencies on QA_PLAN_CHAR_ACTIONS

Line 2629: FROM qa_plan_char_actions qpca, qa_plan_chars_v qpcv

2625:
2626: --besides fetching the assign type, get the datatype of the assign target
2627: /* CURSOR c2 (pca_id NUMBER) IS
2628: SELECT qpca.assign_type, qpcv.datatype, qpcv.decimal_precision
2629: FROM qa_plan_char_actions qpca, qa_plan_chars_v qpcv
2630: WHERE qpca.plan_char_action_id = pca_id AND
2631: qpca.assigned_char_id = qpcv.char_id; */
2632:
2633: -- Bug 4958778. SQL Repository Fix SQL ID: 15008799

Line 2645: qa_plan_char_actions qpca,

2641: qc.datatype,
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

Line 3114: FROM qa_plan_char_actions

3110: ORDER BY trigger_sequence, plan_char_action_trigger_id;
3111:
3112: CURSOR action_cursor (rule_id NUMBER) IS
3113: SELECT plan_char_action_id, action_id, message
3114: FROM qa_plan_char_actions
3115: WHERE plan_char_action_trigger_id = rule_id;
3116:
3117: -- Bug 3397484. Added to make a call to changed function perform_immediate_actions
3118: -- see below the data in RowRecord.

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