APPS.SR_UWQ_INTEG dependencies on CS_SR_UWQ_TEAM_COUNT_V

Line 907: from cs_sr_uwq_team_count_v

903:
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

Line 925: l_node_count_view := 'CS_SR_UWQ_TEAM_COUNT_V';

921: l_node_count_view := 'CS_SR_UWQ_EMP_COUNT_V';
922: elsif l_node_detail_record.view_name = 'CS_SR_UWQ_GROUP_V' then
923: l_node_count_view := 'CS_SR_UWQ_GROUP_COUNT_V';
924: elsif l_node_detail_record.view_name = 'CS_SR_UWQ_TEAM_V' then
925: l_node_count_view := 'CS_SR_UWQ_TEAM_COUNT_V';
926: else
927: l_node_count_view := l_node_detail_record.view_name;
928: end if;
929: