APPS.CSM_HA_EVENT_PKG dependencies on WF_NOTIFICATIONS

Line 523: where exists (select 'X' from wf_notifications N

519: delete from wf_items
520: where ITEM_TYPE = p_item_type;
521:
522: delete from wf_notification_attributes NA
523: where exists (select 'X' from wf_notifications N
524: where N.notification_id = NA.notification_id
525: and N.message_type = p_item_type);
526:
527: delete from wf_comments WC

Line 528: where exists (select 'X' from wf_notifications N

524: where N.notification_id = NA.notification_id
525: and N.message_type = p_item_type);
526:
527: delete from wf_comments WC
528: where exists (select 'X' from wf_notifications N
529: where N.notification_id = WC.notification_id
530: and N.message_type = p_item_type);
531:
532: delete from wf_notifications

Line 532: delete from wf_notifications

528: where exists (select 'X' from wf_notifications N
529: where N.notification_id = WC.notification_id
530: and N.message_type = p_item_type);
531:
532: delete from wf_notifications
533: where message_type = p_item_type;
534:
535: delete from wf_routing_rule_attributes RA
536: where exists (select 'X' from wf_routing_rules R