APPS.OKC_REP_SIGN_WF_PVT dependencies on WF_NOTIFICATIONS

Line 923: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1

919:
920: CURSOR notif_csr (p_notification_id NUMBER) IS
921: SELECT fu.user_id user_id, fu.user_name user_name,
922: fu1.user_id original_user_id,fu1.user_name original_user_name
923: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
924: WHERE fu.user_name = wfn.recipient_role
925: AND fu1.user_name = wfn.original_recipient
926: AND wfn.notification_id = p_notification_id ;
927: