no output in output files [Oracle Applications]
PROCEDURE show_prog_maxminavg (u_con_prog_name varchar2, u_no_of_days number)
is
cursor cal_prog_avg
is
select v.user_concurrent_program_name, c.concurrent_program_id,
round (AVG ( ( nvl(c.actual_completion_date, SYSDATE) - c.ACTUAL_START_DATE)*24*60),3) avg_run_value,
round (MAX ( ( nvl(c.actual_completion_date, SYSDATE) - c.ACTUAL_START_DATE)*24*60),3) max_run_value,
round (MIN ( ( nvl(c.actual_completion_date, SYSDATE) - c.ACTUAL_START_DATE)*24*60),3) min_run_value
from fnd_concurrent_programs_vl v join fnd_concurrent_requests_bkp c
on(v.concurrent_program_id = c.concurrent_program_id)
where v.USER_CONCURRENT_PROGRAM_NAME = u_con_prog_name