259: AND g.OBJECT_ID = o.object_id
260: AND o.obj_name = 'NOTIFICATIONS'
261: AND g.INSTANCE_SET_ID = s.instance_set_id
262: AND s.instance_set_name = 'WL_PROXY_ACCESS'
263: AND g.GRANTEE_KEY = FND_GLOBAL.USER_NAME
264: AND g.INSTANCE_TYPE = 'SET'
265: AND g.START_DATE <= SYSDATE
266: AND Nvl(g.END_DATE, SYSDATE ) >= SYSDATE
267: UNION
264: AND g.INSTANCE_TYPE = 'SET'
265: AND g.START_DATE <= SYSDATE
266: AND Nvl(g.END_DATE, SYSDATE ) >= SYSDATE
267: UNION
268: SELECT FND_GLOBAL.USER_NAME AS granter_key
269: FROM dual;
270:
271: -- Bug 4633202: Temp variables
272: l_notification_key wf_notifications.ACCESS_KEY%TYPE;