APPS.SR_UWQ_INTEG dependencies on JTF_RS_TEAM_MEMBERS

Line 412: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl

408: l_value_flag varchar2(10);
409: l_node_query varchar2(10);
410:
411: cursor team_cursor is select distinct team_mem.team_id,team_tl.team_name
412: from jtf_rs_team_members team_mem, jtf_rs_teams_tl team_tl
413: where team_resource_id = p_resource_id
414: and team_mem.team_id = team_tl.team_id
415: and team_tl.language = userenv('LANG');
416:

Line 908: where resource_id in ( select distinct team_id from jtf_rs_team_members a

904: sr_count := sr_count + n_count;
905:
906: select count(1) into n_count
907: from cs_sr_uwq_team_count_v
908: where resource_id in ( select distinct team_id from jtf_rs_team_members a
909: where a.team_resource_id = p_resource_id
910: and a.team_resource_id = p_resource_id
911: and a.team_resource_id is not null
912: and nvl(a.delete_flag,'N') <> 'Y')