DBA Data[Home] [Help]

APPS.MRP_EXP_WF dependencies on FND_USER_RESP_GROUPS

Line 1703: FROM fnd_user u, fnd_user_resp_groups g

1699: aname => 'FORWARD_TO_USERNAME');
1700:
1701: SELECT g.responsibility_id, g.user_id, g.responsibility_application_id
1702: INTO l_responsibility_id, l_user_id, l_application_id
1703: FROM fnd_user u, fnd_user_resp_groups g
1704: WHERE u.user_name = l_assigned_user
1705: AND g.start_date <= SYSDATE
1706: AND NVL(g.end_date, SYSDATE + 1) >= SYSDATE
1707: AND g.user_id = u.user_id