494: l_gid := WF_ENGINE.context_nid;
495:
496: SELECT responder,notification_id
497: into l_approver_name,l_nid
498: FROM wf_notifications
499: WHERE group_id=l_gid
500: AND status = 'CLOSED';
501:
502: l_result := Wf_Notification.GetAttrText(l_nid, 'RESULT');
498: FROM wf_notifications
499: WHERE group_id=l_gid
500: AND status = 'CLOSED';
501:
502: l_result := Wf_Notification.GetAttrText(l_nid, 'RESULT');
503:
504:
505: if (l_result = 'APPROVED') then -- this may vary based on lookup type used for approval
506: