APPS.AST_OFL_LEAD_ASSIGN_PARAM dependencies on FND_USER

Line 98: , Fnd_user fnu

94: , Jtf_rs_role_relations rrel2
95: , Jtf_rs_roles_b rrb2
96: , Jtf_rs_resource_extns rsc2
97: , Jtf_rs_group_members mem
98: , Fnd_user fnu
99: WHERE grpb.group_id = mem.group_id
100: AND TRUNC(SYSDATE) BETWEEN grpb.start_date_active
101: AND NVL(grpb.end_date_active, TRUNC(SYSDATE))
102: AND rrb2.role_type_code IN ('SALES', 'TELESALES')

Line 145: fnd_user fnu

141: jtf_rs_role_relations rrel2,
142: jtf_rs_roles_b rrb2,
143: jtf_rs_resource_extns rsc2,
144: jtf_rs_group_members mem,
145: fnd_user fnu
146: where grpd.parent_group_id = mem.group_id
147: and nvl(grpd.end_date_active, trunc(sysdate)) >= trunc(sysdate)
148: and rrb2.role_type_code in ('SALES','TELESALES')
149: and (rrb2.admin_flag = 'Y' or rrb2.manager_flag = 'Y')

Line 173: fnd_user fnu

169: UNION
170: select distinct rsc.source_id pid,
171: rsc.source_name flname
172: from jtf_rs_resource_extns rsc,
173: fnd_user fnu
174: where rsc.source_id = fnu.employee_id
175: and fnu.user_id = fnd_global.user_id
176: order by 2;
177: */