APPS.CSY_KPI_PKG dependencies on CSY_PERIODS_V

Line 2310: csy_periods_v per

2306: ending_backlog,
2307: SUM(total_sr_assigned) total_sr_assigned,
2308: SUM(total_sr_reassigned_to_others) total_sr_reassigned_to_others
2309: FROM csy_response_resolutions resp,
2310: csy_periods_v per
2311: WHERE resp.summary_date BETWEEN per.start_date
2312: AND per.end_date
2313: AND owner_type = 'A'
2314: GROUP BY period_type,

Line 2365: csy_periods_v per

2361: ending_backlog,
2362: SUM(total_sr_assigned) total_sr_assigned,
2363: SUM(total_sr_reassigned_to_others) total_sr_reassigned_to_others
2364: FROM csy_response_resolutions resp,
2365: csy_periods_v per
2366: WHERE resp.summary_date BETWEEN per.start_date
2367: AND per.end_date
2368: AND owner_type = 'G'
2369: GROUP BY period_type,

Line 2392: csy_periods_v per

2388: SUM(total_sr_resolved_1st_time) total_sr_resolved_1st_time,
2389: SUM(total_sr_reopened) total_sr_reopened,
2390: SUM(tot_sr_reopened_once_or_more) tot_sr_reopened_once_or_more
2391: FROM csy_resolution_qlty resl,
2392: csy_periods_v per
2393: WHERE resl.summary_date BETWEEN per.start_date
2394: AND per.end_date
2395: GROUP BY period_type,
2396: period_name,