DBA Data[Home] [Help]

APPS.PVX_MISC_PVT dependencies on FND_USER_RESP_GROUPS

Line 1688: FROM fnd_user FNDU, fnd_responsibility FNDR, fnd_user_resp_groups FNDURG, fnd_security_groups FNDSG

1684: ,cv_resp_app_id IN NUMBER) IS
1685: SELECT FNDU.user_name
1686: ,FNDR.responsibility_key
1687: ,FNDSG.security_group_key
1688: FROM fnd_user FNDU, fnd_responsibility FNDR, fnd_user_resp_groups FNDURG, fnd_security_groups FNDSG
1689: WHERE FNDU.user_id = cv_user_id
1690: AND FNDR.responsibility_id = cv_resp_id
1691: AND FNDR.application_id = cv_resp_app_id
1692: AND FNDU.user_id = FNDURG.user_id