DBA Data[Home] [Help]

APPS.ASO_QUOTE_UTIL_PVT dependencies on FND_USER

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

10002:
10003:
10004: Cursor C_APV_UserId(c_notif_id number) IS
10005: Select decode(orig_system, 'FND_USR', orig_system_id, 'PER', a.user_id, NULL) user_id
10006: From wf_roles b, wf_notifications c, fnd_user a
10007: Where b.name = c.recipient_role
10008: And c.notification_id = c_notif_id
10009: And a.employee_id (+) = b.ORIG_SYSTEM_ID;
10010: