USER-WISE CLAIM STATUS REPORT FOR THE PERIOD null-null-null 12:00 AM TO null-null-null 11:59 PM FOR 0 BRANCH
S. No.
NO. OF CLAIMS
USER NAME
BRANCH NAME
Error in the Insured name Query1SELECT INITCAP(P.FIRSTNAME) NAME1,COUNT(distinct cs.CLAIM_NO) cl,s.USERID,INITCAP(mtb.branchhead_name) branchhead_name FROM CLAIM_STAGES CS,LOGINDETAIL L,SIGNINUSER S,PROFILE P,MASTER_STATUS ms,master_tpa_branch mtb WHERE S.LOGINDETAILID=L.LOGINDETAILID AND CS.ACTION_BY=S.USERID AND P.PROFILEID=S.PROFILEID AND ms.STATUS_CODE = cs.STAGE_CODE AND ms.STATUS_CODE IN (3,4,6,7,11,14,30,24,13,23,24,25,35,36,37,12,35,2,12,47) AND l.BRANCH_ID='0' AND CS.ACTION_DATE BETWEEN TO_DATE('null-null-null 12:00 AM ','DD-Mon-YYYY hh:mi am') AND TO_DATE('null-null-null 11:59 PM ','DD-Mon-YYYY hh:mi pm') and mtb.branch_id=l.branch_id GROUP BY P.FIRSTNAME,s.USERID,mtb.branchhead_name ORDER BY 4 java.sql.SQLDataException: ORA-01858: a non-numeric character was found where a numeric was expected