Journal Approval workflow : retrieve Ledger attributes function is returning Fail

Hi , 

I am trying to remediate Journal approval workflow in R12 based on what the client has done in 11.5.10 instance.

But i am finding that the out of box workflow is failing the RETRIEVE_SOB_ATTRIBUTES .

I am finding that the cursor code has following  

 CURSOR batch_ledgers (v_batch_id NUMBER, v_curr_ledger_id NUMBER) IS

    SELECT led.ledger_id

    FROM   GL_LEDGERS led

    WHERE  led.ledger_id IN (SELECT jeh.ledger_id

                             FROM   GL_JE_HEADERS jeh

                             WHERE  jeh.je_batch_id = v_batch_id)

    AND    led.ledger_id > v_curr_ledger_id

    ORDER BY led.ledger_id;