APPS.AST_OFL_LEAD_ASSIGN_PARAM dependencies on JTF_RS_RESOURCE_EXTNS

Line 96: , Jtf_rs_resource_extns rsc2

92: , rrb2.manager_flag
93: FROM Jtf_rs_groups_b grpb
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

Line 124: from JTF_RS_RESOURCE_EXTNS

120: ORDER BY 2 DESC;
121:
122: CURSOR cur_sales_rep(iUserID NUMBER) IS
123: select distinct source_id pid, source_name flname
124: from JTF_RS_RESOURCE_EXTNS
125: where source_id in (
126: select distinct b.person_id
127: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
128: where b.manager_person_id = a.source_id

Line 127: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a

123: select distinct source_id pid, source_name flname
124: from JTF_RS_RESOURCE_EXTNS
125: where source_id in (
126: select distinct b.person_id
127: from jtf_rs_rep_managers b, JTF_RS_RESOURCE_EXTNS a
128: where b.manager_person_id = a.source_id
129: and a.user_id = iUserID
130: );
131:

Line 135: from jtf_rs_resource_extns rsc,

131:
132: /*
133: select distinct rsc.source_id pid,
134: rsc.source_name flname
135: from jtf_rs_resource_extns rsc,
136: jtf_rs_group_members gmem,
137: jtf_rs_role_relations rrel,
138: jtf_rs_roles_b rrb,
139: (select distinct grpd.group_id

Line 143: jtf_rs_resource_extns rsc2,

139: (select distinct grpd.group_id
140: from jtf_rs_groups_denorm grpd,
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)

Line 172: from jtf_rs_resource_extns rsc,

168: and gmem.delete_flag='N'
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;