DBA Data[Home] [Help]

APPS.QA_MQA_PLAN_ELEMENTS dependencies on QA_PLAN_CHAR_ACTION_TRIGGERS

Line 210: FROM qa_plan_char_action_triggers

206: result BOOLEAN;
207: dummy NUMBER;
208: CURSOR c IS
209: SELECT plan_char_action_trigger_id
210: FROM qa_plan_char_action_triggers
211: WHERE plan_id = x_plan_id AND
212: char_id = x_char_id;
213: BEGIN
214: OPEN c;

Line 283: qa_plan_char_action_triggers qpcat,

279: qpca.assigned_char_id,
280: qpca.assign_type,
281: 1 online_flag
282: FROM
283: qa_plan_char_action_triggers qpcat,
284: qa_plan_char_actions qpca,
285: qa_actions qa
286: WHERE
287: qpcat.plan_id = x_plan_id AND

Line 313: qa_plan_char_action_triggers qpcat

309: -1, -- action details, -1 in this case
310: null, -- action details, null in this case
311: 1 -- online flag, always 1 in this case
312: FROM
313: qa_plan_char_action_triggers qpcat
314: WHERE
315: qpcat.plan_id = x_plan_id AND
316: qpcat.char_id = x_char_id AND
317: NOT EXISTS