APPS.PA_BILL_REV_XLA_UPGRADE dependencies on PA_PRIM_REP_LEGER_TMP

Line 25: ' PA_PRIM_REP_LEGER_tmp per ' ||

21: BEGIN
22:
23: l_sql_stmt := 'select je_header_id id_value ' ||
24: ' FROM gl_je_headers hd, ' ||
25: ' PA_PRIM_REP_LEGER_tmp per ' ||
26: ' where hd.LEDGER_ID = per.denorm_ledger_id ' ||
27: ' and hd.PERIOD_NAME = per.PERIOD_NAME ' ||
28: ' and hd.je_source = ''Project Accounting'' ' ||
29: ' and per.batch_id = ' || p_batch_id ;

Line 62: /*Bug 4943551 Changed the logic by using a new table PA_PRIM_REP_LEGER_tmp */

58:
59: WHILE ( l_any_rows_to_process = TRUE )
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'

Line 72: PA_PRIM_REP_LEGER_tmp per

68: AND gl.je_header_id >= l_start_jeid
69: AND gl.je_header_id <= l_end_jeid
70: and EXISTS ( select 'X'
71: from gl_je_headers hd,
72: PA_PRIM_REP_LEGER_tmp per
73: where hd.je_header_id >= l_start_jeid
74: and hd.je_header_id <= l_end_jeid
75: and hd.LEDGER_ID = per.denorm_ledger_id
76: and hd.PERIOD_NAME = per.PERIOD_NAME