APPS.AST_OFL_ACCESSES_REPORT dependencies on JTF_RS_RESOURCE_EXTNS

Line 72: jtf_rs_resource_extns rsc2,

68: (select distinct grpb.group_id, rrb2.manager_flag
69: from jtf_rs_groups_b grpb,
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

Line 100: from jtf_rs_resource_extns rsc,

96:
97: CURSOR cur_sales_rep IS
98: select distinct rsc.source_id pid,
99: rsc.source_name flname
100: from jtf_rs_resource_extns rsc,
101: jtf_rs_group_members gmem,
102: jtf_rs_role_relations rrel,
103: jtf_rs_roles_b rrb,
104: (select distinct grpd.group_id

Line 108: jtf_rs_resource_extns rsc2,

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

Line 137: from jtf_rs_resource_extns rsc,

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

Line 212: FROM jtf_rs_resource_extns rsc,

208: END LOOP;
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,