APPS.AST_OFL_ACCESSES_REPORT dependencies on FND_USER

Line 74: fnd_user fnu

70: jtf_rs_role_relations rrel2,
71: jtf_rs_roles_b rrb2,
72: jtf_rs_resource_extns rsc2,
73: jtf_rs_group_members mem,
74: fnd_user fnu
75: where grpb.group_id = mem.group_id
76: and trunc(sysdate) between grpb.start_date_active
77: and nvl(grpb.end_date_active, trunc(sysdate))
78: and rrb2.role_type_code in ('SALES','TELESALES')

Line 110: fnd_user fnu

106: jtf_rs_role_relations rrel2,
107: jtf_rs_roles_b rrb2,
108: jtf_rs_resource_extns rsc2,
109: jtf_rs_group_members mem,
110: fnd_user fnu
111: where grpd.parent_group_id = mem.group_id
112: and nvl(grpd.end_date_active, trunc(sysdate)) >= trunc(sysdate)
113: and rrb2.role_type_code in ('SALES','TELESALES')
114: and (rrb2.admin_flag = 'Y' or rrb2.manager_flag = 'Y')

Line 138: fnd_user fnu

134: UNION
135: select distinct rsc.source_id pid,
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:

Line 213: fnd_user fnu

209: ELSE
210: SELECT rsc.source_name, rsc.source_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);