487: l_gid := WF_ENGINE.context_nid;
488:
489: SELECT responder,notification_id
490: into l_approver_name,l_nid
491: FROM wf_notifications
492: WHERE group_id=l_gid
493: AND status = 'CLOSED';
494:
495: l_result := Wf_Notification.GetAttrText(l_nid, 'RESULT');
491: FROM wf_notifications
492: WHERE group_id=l_gid
493: AND status = 'CLOSED';
494:
495: l_result := Wf_Notification.GetAttrText(l_nid, 'RESULT');
496:
497:
498: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval
499: