, TO_CHAR ((SELECT AVD.VOILATION_PRINTING_DATE FROM INS_VIOLATION_AVOIDANCE AVD
     WHERE AVD.VISIT_ID = $P{visitid} AND ROWNUM =1), 'HH:MI' ) AS "INS_TIME_visit1"
     , (CASE  TO_CHAR ((SELECT AVD.VOILATION_PRINTING_DATE FROM INS_VIOLATION_AVOIDANCE AVD
     WHERE AVD.VISIT_ID = $P{visitid} AND ROWNUM =1), 'AM') WHEN 'PM' THEN 'كساء'  WHEN 'AM' THEN 'صباحا' END ) AS "TIME_TYPE_visit1"
--  *----------------------------------------------------------

     , (SELECT TO_CHAR ((SELECT AVD.AVOIDANCE_PRINTING_DATE FROM INS_VIOLATION_AVOIDANCE AVD
     WHERE AVD.VISIT_ID =  $P{visitid} AND ROWNUM =1 ), 'HH:MI') FROM DUAL ) AS "INS_TIME_visit_2"
     , (CASE (SELECT TO_CHAR ((SELECT AVD.AVOIDANCE_PRINTING_DATE FROM INS_VIOLATION_AVOIDANCE AVD
     WHERE AVD.VISIT_ID =  $P{visitid} AND ROWNUM =1 ), 'AM') FROM DUAL ) WHEN 'PM' THEN 'كساء'  WHEN 'AM' THEN 'صباحا' END ) AS "TIME_TYPE_visit_2"