APPS.EGO_GROUP_WF_PKG dependencies on WF_USERS

Line 969: l_mail_pref wf_users.notification_preference%TYPE;

965: -- SELECT users.user_name
966: -- FROM fnd_user users
967: -- WHERE users.customer_id = cp_party_id;
968:
969: l_mail_pref wf_users.notification_preference%TYPE;
970: l_owner_name fnd_user.user_name%TYPE;
971: l_user_name fnd_user.user_name%TYPE;
972:
973: BEGIN

Line 2459: FROM wf_user_roles a, wf_users b

2455: mdebug (' GET_RESPONDER_NAME (GRN) : ....5.... email: ' || l_email_address);
2456: BEGIN
2457: SELECT A.user_name
2458: INTO l_responder_name
2459: FROM wf_user_roles a, wf_users b
2460: WHERE a.user_name = b.name
2461: AND a.role_name = G_GROUP_OBJECT_NAME || itemkey
2462: AND upper(b.EMAIL_ADDRESS) = upper(l_email_address)
2463: AND rownum = 1;