APPS.JTF_RS_DBI_CONC_PUB dependencies on JTF_RS_RESOURCE_EXTNS

Line 306: FROM jtf_rs_rep_managers mgr, jtf_rs_resource_extns res

302: , usg.usage
303: FROM (
304: SELECT /*+ use_hash(res mgr) parallel(res) parallel(mgr) */
305: DISTINCT mgr.resource_id, res.user_id, mgr.group_id
306: FROM jtf_rs_rep_managers mgr, jtf_rs_resource_extns res
307: WHERE mgr.hierarchy_type IN ('MGR_TO_MGR','ADMIN_TO_ADMIN')
308: AND mgr.resource_id = mgr.parent_resource_id
309: AND l_bis_date BETWEEN mgr.start_date_active
310: AND NVL(mgr.end_date_active,to_date('12/31/4712','MM/DD/RRRR'))

Line 634: ,jtf_rs_resource_extns_vl res

630: usg.usage
631: FROM jtf_rs_group_members gm
632: ,jtf_rs_role_relations rrl
633: ,jtf_rs_roles_b rol
634: ,jtf_rs_resource_extns_vl res
635: ,jtf_rs_group_usages usg
636: WHERE gm.delete_flag = 'N'
637: AND gm.group_member_id = rrl.role_resource_id
638: AND rrl.role_resource_type = 'RS_GROUP_MEMBER'