DBA Data[Home] [Help]

APPS.WSH_RU_ACTIONS dependencies on WSH_ROLE_PRIVILEGES

Line 387: wsh_role_privileges rp

383:
384: CURSOR c_privileges(x_org_id IN NUMBER, x_user_id IN NUMBER) IS
385: SELECT DISTINCT rp.privilege_code
386: FROM wsh_grants g,
387: wsh_role_privileges rp
388: WHERE g.user_id = x_user_id
389: AND sysdate BETWEEN g.start_date AND NVL(g.end_date, sysdate)
390: AND NVL(g.organization_id, NVL(x_org_id, -1))
391: = NVL(x_org_id, NVL(g.organization_id, -1))

Line 459: wsh_role_privileges rp

455: CURSOR c_access(x_org_id IN NUMBER, x_priv IN VARCHAR2,
456: x_user_id IN NUMBER) IS
457: SELECT 'Y'
458: FROM wsh_grants g,
459: wsh_role_privileges rp
460: WHERE g.user_id = x_user_id
461: AND sysdate BETWEEN g.start_date AND NVL(g.end_date, sysdate)
462: AND rp.role_id = g.role_id
463: AND NVL(g.organization_id, NVL(x_org_id, -1))