DBA Data[Home] [Help]

APPS.ASO_QUOTE_UTIL_PVT dependencies on WF_NOTIFICATIONS

Line 9970: From wf_roles b, wf_notifications c, fnd_user a

9966:
9967:
9968: Cursor C_APV_UserId(c_notif_id number) IS
9969: Select decode(orig_system, 'FND_USR', orig_system_id, 'PER', a.user_id, NULL) user_id
9970: From wf_roles b, wf_notifications c, fnd_user a
9971: Where b.name = c.recipient_role
9972: And c.notification_id = c_notif_id
9973: And a.employee_id (+) = b.ORIG_SYSTEM_ID;
9974: