948:
949: CURSOR notif_csr (p_notification_id NUMBER) IS
950: SELECT fu.user_id user_id, fu.user_name user_name,
951: fu1.user_id original_user_id,fu1.user_name original_user_name
952: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
953: WHERE fu.user_name = wfn.recipient_role
954: AND fu1.user_name = wfn.original_recipient
955: AND wfn.notification_id = p_notification_id ;
956:
1288:
1289: CURSOR notif_csr (p_notification_id NUMBER) IS
1290: SELECT fu.user_id user_id, fu.user_name user_name,
1291: fu1.user_id original_user_id,fu1.user_name original_user_name
1292: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
1293: WHERE fu.user_name = wfn.recipient_role
1294: AND fu1.user_name = wfn.original_recipient
1295: AND wfn.notification_id = p_notification_id ;
1296: