eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_RU_ACTIONS dependencies on WSH_GRANTS

Line 386: FROM wsh_grants g,

382: x_return_status OUT NOCOPY VARCHAR2) IS
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))

Line 458: FROM wsh_grants g,

454:
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

Line 801: ,wsh_grants grants

797: ,p_validation_code in VARCHAR2
798: ,p_lookup_type in VARCHAR2) is
799: select msgs.activity_code , msgs.validation_code , msgs.return_status
800: from wsh_customized_activity_msgs msgs
801: ,wsh_grants grants
802: ,wsh_lookups activity
803: ,wsh_lookups message
804: where grants.user_id = p_user_id
805: and sysdate between nvl(grants.start_date,sysdate) and nvl(grants.end_date,sysdate )