DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on FND_USER_RESP_GROUPS_ALL

Line 2721: from fnd_user_resp_groups_all a,

2717: --Get all the responsibilities for the user
2718: CURSOR user_resp_csr(p_user_id NUMBER) is
2719: select a.responsibility_id, c.application_id,
2720: b.responsibility_key, c.application_short_name
2721: from fnd_user_resp_groups_all a,
2722: fnd_responsibility_vl b,
2723: fnd_application c
2724: where a.user_id = p_user_id
2725: and sysdate between NVL(a.start_date,sysdate) and NVL(a.end_date,sysdate)