DBA Data[Home] [Help]

APPS.PA_CI_SECURITY_PKG dependencies on FND_USER_RESP_GROUPS_ALL

Line 862: from fnd_user_resp_groups_all a,

858: --Get all the responsibilities for the user
859: CURSOR user_resp_csr(p_user_id NUMBER) is
860: select a.responsibility_id, c.application_id,
861: b.responsibility_key, c.application_short_name
862: from fnd_user_resp_groups_all a,
863: fnd_responsibility_vl b,
864: fnd_application c
865: where a.user_id = p_user_id
866: and sysdate between NVL(a.start_date,sysdate) and NVL(a.end_date,sysdate)