DBA Data[Home] [Help]

APPS.JTF_RS_DEFAULT_GROUPS_CONC_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 238: ,jtf_rs_resource_extns res

234: ,jtf_rs_group_members mem
235: ,jtf_rs_group_usages usg
236: ,jtf_rs_roles_b rol
237: ,jtf_rs_groups_denorm den
238: ,jtf_rs_resource_extns res
239: WHERE rrl.role_resource_type = 'RS_GROUP_MEMBER'
240: AND rrl.delete_flag = 'N'
241: AND rrl.role_resource_id = mem.group_member_id
242: AND mem.delete_flag = 'N'

Line 302: ,jtf_rs_resource_extns res

298: TO_DATE('12/31/4712','MM/DD/RRRR') END_DATE,
299: 99999999 denorm_count
300: FROM jtf_rs_role_relations rrl
301: ,jtf_rs_roles_b rol
302: ,jtf_rs_resource_extns res
303: WHERE rrl.role_resource_type = 'RS_INDIVIDUAL'
304: AND rrl.delete_flag = 'N'
305: AND rrl.role_id = rol.role_id
306: AND rol.role_type_code IN ('CSF_REPRESENTATIVE','CSF_DEBRIEF',