DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on FND_RESPONSIBILITY_VL

Line 2722: fnd_responsibility_vl b,

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)
2726: and a.responsibility_id = b.responsibility_id