DBA Data[Home] [Help]

APPS.QLTCPDFB dependencies on QA_PLAN_CHAR_ACTIONS_V

Line 232: FROM qa_plan_char_actions_v qpcav

228: WHERE aa.application_id = X_qa_app_id
229: AND aa.alert_id = X_qa_alert_id
230: AND aa.action_id in
231: (SELECT qpcav.alr_action_id
232: FROM qa_plan_char_actions_v qpcav
233: WHERE PLAN_ID = X_PLAN_ID
234: AND CHAR_ID = X_CHAR_ID);
235:
236: -- Delete existing alr_action_sets

Line 243: FROM qa_plan_char_actions_v qpcav

239: WHERE aas.application_id = X_qa_app_id
240: AND aas.alert_id = X_qa_alert_id
241: AND aas.action_set_id in
242: (SELECT qpcav.alr_action_set_id
243: FROM qa_plan_char_actions_v qpcav
244: WHERE PLAN_ID = X_PLAN_ID
245: AND CHAR_ID = X_CHAR_ID);
246:
247: -- Delete existing alr_action_set_members

Line 254: FROM qa_plan_char_actions_v qpcav

250: WHERE aasm.application_id = X_qa_app_id
251: AND aasm.alert_id = X_qa_alert_id
252: AND aasm.action_set_id in
253: (SELECT qpcav.alr_action_set_id
254: FROM qa_plan_char_actions_v qpcav
255: WHERE PLAN_ID = X_PLAN_ID
256: AND CHAR_ID = X_CHAR_ID);
257:
258: -- Delete existing action triggers