180: l.invoice_identifier,
181: l.invoice_amount,
182: l.ussgl_transaction_code--,
183: --l.jgzz_recon_ref
184: FROM gl_je_lines l
185: WHERE l.je_header_id = p_header_id;
186:
187: CURSOR c_ref( p_header_id NUMBER,
188: p_line_num NUMBER) IS
310: ---------------------------------------------------------
311: FOR rec_header IN c_header (rec_batch.je_batch_id,x_from_ledger.set_of_books_id) LOOP
312:
313: ---------------------------------------------------------
314: -- Get information from gl_je_lines --
315: ---------------------------------------------------------
316: FOR rec_line IN c_line( rec_header.je_header_id) LOOP
317: ---------------------------------------------------------
318: -- Assiging the Line References as default references --