Need help to modify SQL to retrieve the journal approver field please

Summary: I am trying to update the GL Ledger script to include the following additional fields

• Journal Approver name
• beginning and closing GL account balances for the selected year

Thanks

Content (please ensure you mask any confidential information):

SELECT
'NEW' NEW,
GLL.NAME GLL_LEDGER_ID,
to_date(JEL.EFFECTIVE_DATE,'YYYY-MM-DD') EFFECTIVE_DATE_OF_TRANSACTION,
jes.JE_SOURCE_key JEH_SOURCE,
case when JEC.JE_CATEGORY_key = 'A_ADJ' THEN 'A Adjustment'
when JEC.JE_CATEGORY_key = 'A_TB' THEN 'A Trial Balance'
when JEC.JE_CATEGORY_key = 'A_ISC' THEN 'A Income Statement Close'
when JEC.JE_CATEGORY_key = 'A_INV_AM' THEN 'A Investment - AM'