APPS.CSY_KPI_PKG dependencies on CSY_RESOLUTION_QLTY

Line 883: update csy_resolution_qlty

879: l_sr_resolved,
880: l_sr_reopen,
881: l_sr_reopen2;
882: if c_first_resolutions%notfound then exit; end if;
883: update csy_resolution_qlty
884: set total_sr_resolved_1st_time = nvl(total_sr_resolved_1st_time,0) +
885: l_sr_resolved,
886: total_sr_reopened = nvl(total_sr_reopened,0)+l_sr_reopen,
887: tot_sr_reopened_once_or_more = nvl(tot_sr_reopened_once_or_more,0)+

Line 898: insert into csy_resolution_qlty (

894: and inventory_item_id = l_inv_item_id
895: and resolution_code = l_resol_code
896: and problem_code = l_prob_code;
897: if (sql%notfound ) then
898: insert into csy_resolution_qlty (
899: SUMMARY_DATE ,
900: INCIDENT_OWNER_ID ,
901: OWNER_TYPE ,
902: INCIDENT_SEVERITY_ID ,

Line 2198: delete from csy_resolution_qlty;

2194: into l_min_date
2195: from cs_incidents_audit_b;
2196: */
2197: delete from csy_response_resolutions;
2198: delete from csy_resolution_qlty;
2199: commit;
2200: l_min_date := trunc(sysdate) - 370;
2201: l_ret_val := fnd_profile.save('CS_CSY_LAST_PROGRAM_RUN_DATE',
2202: to_char(l_min_date,'YYYYMMDD hh24:mi:ss'),