113: s.je_source_name,
114: s.journal_reference_flag,
115: c.user_je_category_name,
116: c.je_category_name
117: FROM gl_je_headers h,
118: gl_je_sources s,
119: gl_je_categories c,
120: gl_daily_conversion_types d
121: WHERE h.je_source = s.je_source_name
305: ---------------------------------------------------------
306: FOR rec_batch IN c_batch LOOP
307:
308: ---------------------------------------------------------
309: -- Get information from gl_je_headers --
310: ---------------------------------------------------------
311: FOR rec_header IN c_header (rec_batch.je_batch_id,x_from_ledger.set_of_books_id) LOOP
312:
313: ---------------------------------------------------------
748: END IF;
749:
750: END IF;
751: ---------------------------------------------------------
752: -- UPDATE gl_je_headers --
753: ---------------------------------------------------------
754:
755: UPDATE gl_je_headers
756: SET global_attribute1 = to_char(rec_header.je_header_id)
751: ---------------------------------------------------------
752: -- UPDATE gl_je_headers --
753: ---------------------------------------------------------
754:
755: UPDATE gl_je_headers
756: SET global_attribute1 = to_char(rec_header.je_header_id)
757: WHERE CURRENT OF c_header;
758:
759: END LOOP;