APPS.PA_BILL_REV_XLA_UPGRADE dependencies on GL_JE_HEADERS

Line 24: ' FROM gl_je_headers hd, ' ||

20: l_sql_stmt VARCHAR2(2000);
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'' ' ||

Line 71: from gl_je_headers hd,

67: WHERE gl.gl_sl_link_id is NULL
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