APPS.AZW_REPORT dependencies on WF_NOTIFICATIONS

Line 5884: v_user_comments wf_notifications.user_comment%TYPE := NULL;

5880: AND wiasv.item_type = wpa.process_item_type
5881: AND wpa.process_name = p_process_name
5882: AND wpa.instance_id = wiasv.activity_id
5883: ORDER BY 5, 6;
5884: v_user_comments wf_notifications.user_comment%TYPE := NULL;
5885: BEGIN
5886:
5887: --
5888: -- Start looping through all the steps for the current specified process

Line 5896: FROM wf_notifications

5892: -- Get the user comment if there is a notification
5893: --
5894: IF step.notification_id IS NOT NULL THEN
5895: SELECT user_comment INTO v_user_comments
5896: FROM wf_notifications
5897: WHERE notification_id = step.notification_id;
5898: END IF;
5899:
5900: IF step.type = 'PROCESS' THEN