18: CURSOR cu_gir(p_je_batch_id IN NUMBER) IS
19: SELECT jle.code_combination_id,
20: gir.rowid,
21: gir.reference_1,
22: xla_gl_sl_link_id_s.nextval
23: FROM gl_je_headers gh,
24: gl_import_references gir,
25: gl_je_lines jle
26: WHERE gh.je_batch_id = p_je_batch_id
172: CURSOR cu_gir(p_je_batch_id IN NUMBER) IS
173: SELECT jle.code_combination_id,
174: gir.rowid,
175: gir.reference_1,
176: xla_gl_sl_link_id_s.nextval
177: FROM gl_je_headers gh,
178: gl_import_references gir,
179: gl_je_lines jle
180: WHERE gh.je_batch_id = p_je_batch_id