APPS.PA_BILL_REV_XLA_UPGRADE dependencies on GL_IMPORT_REFERENCES

Line 64: UPDATE GL_IMPORT_REFERENCES gl

60: LOOP
61:
62: /*Bug 4943551 Changed the logic by using a new table PA_PRIM_REP_LEGER_tmp */
63:
64: UPDATE GL_IMPORT_REFERENCES gl
65: SET gl.gl_sl_link_id = xla_gl_sl_link_id_s.nextval,
66: gl.gl_sl_link_table = 'XLAJEL'
67: WHERE gl.gl_sl_link_id is NULL
68: AND gl.je_header_id >= l_start_jeid

Line 813: FROM GL_IMPORT_REFERENCES imp,

809: p_rows_process := p_rows_process + SQL%ROWCOUNT;
810:
811: UPDATE XLA_AE_LINES lin
812: SET lin.gl_sl_link_id = (SELECT gl_sl_link_id
813: FROM GL_IMPORT_REFERENCES imp,
814: PA_REV_AE_LINES_TMP tmp
815: WHERE imp.reference_6 = tmp.gl_batch_name
816: AND imp.reference_2 = tmp.code_combination_id
817: AND imp.reference_3 = tmp.dist_type

Line 1545: FROM GL_IMPORT_REFERENCES imp,

1541: p_rows_process := p_rows_process + SQL%ROWCOUNT;
1542:
1543: UPDATE XLA_AE_LINES lin
1544: SET lin.gl_sl_link_id = (select gl_sl_link_id
1545: FROM GL_IMPORT_REFERENCES imp,
1546: PA_REV_AE_LINES_TMP tmp
1547: WHERE imp.reference_6 = tmp.gl_batch_name
1548: AND imp.reference_2 = tmp.code_combination_id
1549: AND imp.reference_3 = tmp.dist_type