{"iTotalDisplayRecords":"0","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `advance_id`, `requested_amount`, `approved_amount`, `status`, `request_remarks`, `tenure`, `instalment`, `effective_from`, `deduction_status`, `opening_balance`, `requested_by`, `requested_on`, `approved_by`, `approved_on`, `approved_remarks`, `issued_by`, `issued_on`, `issue_remarks`, `settled_by`, `settled_on`, `settled_remarks`, `requested_user_name`, `approved_user_name`, `issued_user_name`, `settled_user_name`\r\n    FROM salary_advance_view\r\n    \r\n    ORDER BY requested_on ASC\r\n    \r\n    ","aaData":[]}