APPS.JTF_TTY_NACCT_SALES_PUB dependencies on JTF_RS_GROUPS_DENORM

Line 122: jtf_rs_groups_denorm gd

118: -- LIST OF ALL GROUPS A GIVEN RESOURCE OWNS IN THE CONTEXT OF A PARENT GRUOP
119: cursor c_rsc_owned_grps(cl_parent_resource_id number, cl_group_id number) is
120: SELECT mgr.resource_id, mgr.group_id
121: FROM jtf_rs_rep_managers mgr,
122: jtf_rs_groups_denorm gd
123: WHERE mgr.hierarchy_type = 'MGR_TO_MGR'
124: AND mgr.resource_id = mgr.parent_resource_id
125: AND trunc(sysdate) BETWEEN mgr.start_date_active
126: AND NVL(mgr.end_date_active,trunc(sysdate))

Line 187: jtf_rs_groups_denorm grpden

183: jtf_rs_role_relations rlt,
184: jtf_rs_roles_b rol,
185: jtf_rs_group_members cgrpmem,
186: jtf_rs_resource_extns crsc,
187: jtf_rs_groups_denorm grpden
188: where crsc.user_id = cl_current_user_id
189: and crsc.resource_id = cgrpmem.resource_id
190: and cgrpmem.delete_flag = 'N'
191: and cgrpmem.group_id = mem.group_id

Line 598: , jtf_rs_groups_denorm grpd

594: where ar.terr_group_account_id = l_terr_group_account_id
595: and exists (
596: select 1
597: from jtf_tty_my_resources_v grv
598: , jtf_rs_groups_denorm grpd
599: WHERE ar.resource_id = grv.resource_id
600: and grpd.parent_group_id = grv.parent_group_id
601: and exists (
602: select 1