549: return l_username;
550: end if;
551:
552: -- If the responder was purged from directory service, check for the
553: -- denormalized value from wf_comments table
554: SELECT wc.from_user
555: INTO l_username
556: FROM wf_notifications wn,
557: wf_comments wc
553: -- denormalized value from wf_comments table
554: SELECT wc.from_user
555: INTO l_username
556: FROM wf_notifications wn,
557: wf_comments wc
558: WHERE wn.notification_id = p_notification_id
559: AND wn.notification_id = wc.notification_id
560: AND wn.responder = wc.from_role
561: AND wc.action_type = 'RESPOND'