DBA Data[Home] [Help]

APPS.OKC_REP_WF_PVT dependencies on WF_NOTIFICATIONS

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

807:
808: CURSOR notif_csr (p_notification_id NUMBER) IS
809: SELECT fu.user_id user_id, fu.user_name user_name,
810: fu1.user_id original_user_id,fu1.user_name original_user_name
811: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
812: WHERE fu.user_name = wfn.recipient_role
813: AND fu1.user_name = wfn.original_recipient
814: AND wfn.notification_id = p_notification_id ;
815:

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

1122:
1123: CURSOR notif_csr (p_notification_id NUMBER) IS
1124: SELECT fu.user_id user_id, fu.user_name user_name,
1125: fu1.user_id original_user_id,fu1.user_name original_user_name
1126: FROM fnd_user fu, wf_notifications wfn, fnd_user fu1
1127: WHERE fu.user_name = wfn.recipient_role
1128: AND fu1.user_name = wfn.original_recipient
1129: AND wfn.notification_id = p_notification_id ;
1130: