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)