{"iTotalDisplayRecords":"0","query":"\r\n  SELECT SQL_CALC_FOUND_ROWS `payment_id`, `receipt_number`, `company_id`, `project_id`, `expense_type`, `payment_type`, `requested_amount`, `request_remarks`, `requested_on`, `requested_by`, `approved_by`, `approved_on`, `approve_remark`, `issued_by`, `issued_on`, `issued_amount`, `issue_remark`, `status`, `settlement_amount`, `settlement_status`, `settlement_date`, `instrument_date`, `instrument_type`, `instrument_number`, `settlement_remarks`, `tally_status`, `payment_requested_user`, `payment_approved_user`, `payment_issued_user`, `project_name`, `payment_mode_name`, `stock_company_master_name`, `stock_company_master_address`, `user_department`, `general_task_department_name`\r\n  FROM advance_payment_view\r\n   Where ((`payment_type` = '1' AND `status` = 'Issued' AND `settlement_status` = '3') OR (`payment_type` = '2' AND `status` = 'Issued'))\r\n  ORDER BY issued_on DESC\r\n  \r\n  ","aaData":[]}