-------------------------mass disable reports----------------------
update xxen_reports xr set
xr.disabled='Y',
xr.last_updated_by=fnd_global.user_id,
xr.last_update_date=sysdate
where
xr.disabled is null and
xr.report_id in (select xrt.report_id from xxen_reports_tl xrt where xrt.language='US' and xrt.report_name like 'PAY %');