{"iTotalDisplayRecords":"0","query":"\r\n    SELECT SQL_CALC_FOUND_ROWS `payment_id`, `receipt_number`, `process_plan_id`, `requested_amount`, `request_remarks`, `requested_on`, `requested_by`, `approved_by`, `approved_on`, `approve_remark`, `issued_by`, `issued_on`, `issued_amount`, `issue_remark`, `status`, `advance_food_expence`, `advance_transport_expence`, `settlement_amount`, `actual_food_expence`, `actual_tranport_expence`, `settlement_status`, `settlement_date`, `instrument_date`, `instrument_type`, `instrument_number`, `payment_requested_user`, `payment_approved_user`, `payment_issued_user`, `project_id`, `bd_project_name`, `village_name`, `payment_mode_name`, `company_name`, `file_extent`, `file_survey_number`, `file_number`, `process_name`, `is_document_payment`, `payment_type`, `p_settlement_id`, `p_settlement_amount`, `p_requested_by`, `p_requested_on`, `p_approved_by`, `p_approved_on`, `p_issued_by`, `p_issued_on`, `p_settlement_status`\r\n    FROM bd_document_payment\r\n    where `status` = 'Issued'\r\n    ORDER BY requested_on ASC\r\n    \r\n    ","aaData":[]}