aonestar
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
sp_get_payment_codes_js
Description
List all payment codes
Parameters
Name
Type
Mode
Definition
WITH list AS ( SELECT dp.id, dp.code, dp.name, dp.group_id, dg."name" AS group_name, dp.post_type, dept_type, require_info, tax_code FROM department dp LEFT JOIN department_group dg ON dg.id = dp.group_id WHERE dp.post_type = 'S' AND dp.enabled ) SELECT json_agg(list) FROM list