APPS.BIX_UWQ_TEMP_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 86: from jtf_rs_group_members grp, jtf_rs_resource_extns res

82: BEGIN
83:
84: select grp.group_id
85: into v_default_group_id
86: from jtf_rs_group_members grp, jtf_rs_resource_extns res
87: where res.resource_id = grp.resource_id
88: and res.user_id = fnd_profile.value('USER_ID')
89: and grp.last_update_date = (select max(grp2.last_update_date)
90: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2

Line 90: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2

86: from jtf_rs_group_members grp, jtf_rs_resource_extns res
87: where res.resource_id = grp.resource_id
88: and res.user_id = fnd_profile.value('USER_ID')
89: and grp.last_update_date = (select max(grp2.last_update_date)
90: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2
91: where res2.resource_id = grp2.resource_id
92: and res2.user_id = fnd_profile.value('USER_ID')
93: );
94: EXCEPTION

Line 145: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

141:
142: CURSOR c_child_agents(p_group_id INTEGER)
143: IS
144: SELECT DISTINCT res.resource_id RID, res.source_name RNAME
145: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
146: WHERE grp.group_id = p_group_id
147: AND grp.resource_id = res.resource_id;
148:
149: BEGIN

Line 185: from jtf_rs_group_members grp, jtf_rs_resource_extns res

181: BEGIN
182:
183: select grp.group_id
184: into v_default_group_id
185: from jtf_rs_group_members grp, jtf_rs_resource_extns res
186: where res.resource_id = grp.resource_id
187: and res.user_id = fnd_profile.value('USER_ID')
188: and grp.last_update_date = (select max(grp2.last_update_date)
189: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2

Line 189: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2

185: from jtf_rs_group_members grp, jtf_rs_resource_extns res
186: where res.resource_id = grp.resource_id
187: and res.user_id = fnd_profile.value('USER_ID')
188: and grp.last_update_date = (select max(grp2.last_update_date)
189: from jtf_rs_group_members grp2, jtf_rs_resource_extns res2
190: where res.resource_id = grp.resource_id
191: and res.user_id = fnd_profile.value('USER_ID')
192: );
193: EXCEPTION

Line 358: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

354: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
355: WHERE summ.resource_id IN
356: (
357: SELECT DISTINCT res.resource_id
358: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
359: WHERE grp.group_id = substr(v_context,13)
360: AND grp.resource_id = res.resource_id
361: )
362: AND summ.resource_id = res.resource_id

Line 422: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

418: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
419: WHERE summ.resource_id IN
420: (
421: SELECT DISTINCT res.resource_id
422: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
423: WHERE grp.group_id = v_default_group_id
424: AND grp.resource_id = res.resource_id
425: )
426: AND summ.resource_id = res.resource_id

Line 572: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

568: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
569: WHERE summ.resource_id IN
570: (
571: SELECT DISTINCT res.resource_id
572: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
573: WHERE grp.group_id = substr(v_context,13)
574: AND grp.resource_id = res.resource_id
575: )
576: AND summ.resource_id = res.resource_id

Line 663: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res

659: FROM bix_dm_uwq_agent_sum summ, jtf_rs_resource_extns res
660: WHERE summ.resource_id IN
661: (
662: SELECT DISTINCT res.resource_id
663: FROM jtf_rs_group_members grp, jtf_rs_resource_extns res
664: WHERE grp.group_id = v_default_group_id
665: AND grp.resource_id = res.resource_id
666: )
667: AND summ.resource_id = res.resource_id