APPS.AST_OFL_ACCESSES_REPORT dependencies on FND_GLOBAL

Line 123: and fnu.user_id = fnd_global.user_id) grps

119: and rrel2.role_resource_id = mem.group_member_id
120: and mem.resource_id = rsc2.resource_id
121: and mem.delete_flag='N'
122: and rsc2.source_id = fnu.employee_id
123: and fnu.user_id = fnd_global.user_id) grps
124: where gmem.group_id = grps.group_id
125: and rsc.resource_id = gmem.resource_id
126: and rrel.role_resource_id = gmem.group_member_id
127: and trunc(sysdate) between rrel.start_date_active

Line 140: and fnu.user_id = fnd_global.user_id

136: rsc.source_name flname
137: from jtf_rs_resource_extns rsc,
138: fnd_user fnu
139: where rsc.source_id = fnu.employee_id
140: and fnu.user_id = fnd_global.user_id
141: order by 2;
142:
143: BEGIN
144:

Line 215: AND fnu.user_id = fnd_global.user_id;

211: INTO l_flname, l_pid
212: FROM jtf_rs_resource_extns rsc,
213: fnd_user fnu
214: WHERE rsc.source_id = fnu.employee_id
215: AND fnu.user_id = fnd_global.user_id;
216: htp.formSelectOption(l_flname,
217: cAttributes => ' value= ' || l_pid);
218: END IF;
219: /* End of Changes by Thanh Huynh 01/27/01 */