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 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: