APPS.CST_UPD_GIR_MTA_WTA dependencies on GL_IMPORT_REFERENCES

Line 24: gl_import_references gir,

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
27: AND gh.je_header_id = jle.je_header_id
28: AND gir.je_header_id = jle.je_header_id

Line 97: UPDATE gl_import_references

93:
94: debug(' Update GIR.GL_SL_LINK_ID for MTA');
95:
96: FORALL i IN gir_rowid_tab.FIRST .. gir_rowid_tab.LAST
97: UPDATE gl_import_references
98: SET gl_sl_link_id = gl_sl_link_id_tab(i)
99: WHERE rowid = gir_rowid_tab(i);
100:
101: l_sql := SQL%ROWCOUNT;

Line 178: gl_import_references gir,

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
181: AND gh.je_header_id = jle.je_header_id
182: AND gir.je_header_id = jle.je_header_id

Line 247: UPDATE gl_import_references

243:
244: debug(' Update GIR.GL_SL_LINK_ID for WTA');
245:
246: FORALL i IN gir_rowid_tab.FIRST .. gir_rowid_tab.LAST
247: UPDATE gl_import_references
248: SET gl_sl_link_id = gl_sl_link_id_tab(i)
249: WHERE rowid = gir_rowid_tab(i);
250:
251: l_sql := SQL%ROWCOUNT;