While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only

While I am using (AP_INVOICES_PKG.GET_POSTING_STATUS( aia.INVOICE_ID ), the query is processing only and at least I am getting timeout error.

Here is my query. Can you please suggest.

/****************************************************************************
DATA MODEL NAME : LMG_ACCOUNT_PAYABLE_TRIAL_BALANCE_DM
REPORT NAME : LMG Account Payable Trial Balance Report
Change History:
Version Name Date Comments

V1 Manasa Panigrahi 3-April-2025 Initial Version
-----------------------------------------------------------------------------------------------*/
SELECT DISTINCT CASE
WHEN Substr(vl.legal_entity_name, -4) = '_FIN' THEN
Substr(vl.legal_entity_name, 1,
Length(vl.legal_entity_name) - 4)
ELSE vl.legal_entity_name
END "Entity Name",
CASE
WHEN Substr(bu.bu_name, -4) = '_FIN' THEN