APPS.SR_UWQ_INTEG dependencies on JTF_RS_GROUP_MEMBERS

Line 418: from jtf_rs_group_members group_mem, jtf_rs_groups_tl group_tl

414: and team_mem.team_id = team_tl.team_id
415: and team_tl.language = userenv('LANG');
416:
417: cursor group_cursor is select distinct group_mem.group_id,group_tl.group_name
418: from jtf_rs_group_members group_mem, jtf_rs_groups_tl group_tl
419: where group_mem.resource_id = p_resource_id
420: and group_mem.group_id = group_tl.group_id
421: and group_tl.language = userenv('LANG');
422:

Line 896: where resource_id in ( select distinct group_id from jtf_rs_group_members a

892: sr_count := sr_count + n_count;
893:
894: select count(1) into n_count
895: from cs_sr_uwq_group_count_v
896: where resource_id in ( select distinct group_id from jtf_rs_group_members a
897: where a.resource_id = p_resource_id
898: and a.resource_id = p_resource_id
899: and a.resource_id is not null
900: and nvl(a.delete_flag,'N') <> 'Y')

Line 1936: from jtf_rs_group_members group_mem, jtf_rs_groups_tl group_tl

1932: and team_mem.team_id = team_tl.team_id
1933: and team_tl.language = userenv('LANG');
1934:
1935: cursor group_cursor is select distinct group_mem.group_id,group_tl.group_name
1936: from jtf_rs_group_members group_mem, jtf_rs_groups_tl group_tl
1937: where group_mem.resource_id = p_resource_id
1938: and group_mem.group_id = group_tl.group_id
1939: and group_tl.language = userenv('LANG');
1940:

Line 2461: from jtf_rs_group_members group_mem, jtf_rs_groups_tl group_tl

2457: and team_mem.team_id = team_tl.team_id
2458: and team_tl.language = userenv('LANG');
2459:
2460: cursor group_cursor is select distinct group_mem.group_id,group_tl.group_name
2461: from jtf_rs_group_members group_mem, jtf_rs_groups_tl group_tl
2462: where group_mem.resource_id = p_resource_id
2463: and group_mem.group_id = group_tl.group_id
2464: and group_tl.language = userenv('LANG');
2465:

Line 2986: from jtf_rs_group_members group_mem, jtf_rs_groups_tl group_tl

2982: and team_mem.team_id = team_tl.team_id
2983: and team_tl.language = userenv('LANG');
2984:
2985: cursor group_cursor is select distinct group_mem.group_id,group_tl.group_name
2986: from jtf_rs_group_members group_mem, jtf_rs_groups_tl group_tl
2987: where group_mem.resource_id = p_resource_id
2988: and group_mem.group_id = group_tl.group_id
2989: and group_tl.language = userenv('LANG');
2990: