APPS.QA_VALIDATION_API dependencies on QA_PLAN_CHAR_ACTIONS

Line 2562: FROM qa_plan_char_actions qpca, qa_plan_chars_v qpcv

2558:
2559: --besides fetching the assign type, get the datatype of the assign target
2560: /* CURSOR c2 (pca_id NUMBER) IS
2561: SELECT qpca.assign_type, qpcv.datatype, qpcv.decimal_precision
2562: FROM qa_plan_char_actions qpca, qa_plan_chars_v qpcv
2563: WHERE qpca.plan_char_action_id = pca_id AND
2564: qpca.assigned_char_id = qpcv.char_id; */
2565:
2566: -- Bug 4958778. SQL Repository Fix SQL ID: 15008799

Line 2578: qa_plan_char_actions qpca,

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

Line 3047: FROM qa_plan_char_actions

3043: ORDER BY trigger_sequence, plan_char_action_trigger_id;
3044:
3045: CURSOR action_cursor (rule_id NUMBER) IS
3046: SELECT plan_char_action_id, action_id, message
3047: FROM qa_plan_char_actions
3048: WHERE plan_char_action_trigger_id = rule_id;
3049:
3050: -- Bug 3397484. Added to make a call to changed function perform_immediate_actions
3051: -- see below the data in RowRecord.

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