DBA Data[Home] [Help]

APPS.OKC_REP_WF_PVT dependencies on WF_NOTIFICATIONS

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

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:

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

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: