DBA Data[Home] [Help]

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')