DBA Data[Home] [Help]

APPS.SR_UWQ_INTEG dependencies on CS_SR_UWQ_GROUP_COUNT_V

Line 895: from cs_sr_uwq_group_count_v

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

Line 923: l_node_count_view := 'CS_SR_UWQ_GROUP_COUNT_V';

919:
920: if l_node_detail_record.view_name = 'CS_SR_UWQ_EMPLOYEE_V' then
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;