APPS.IGI_IGIGCBGD_XMLP_PKG dependencies on GL_JE_BATCHES

Line 117: GL_JE_BATCHES GJB

113: count(*)
114: INTO LP_UNPOSTED_JOURNALS
115: FROM
116: GL_JE_HEADERS GJH,
117: GL_JE_BATCHES GJB
118: WHERE GJH.LEDGER_ID = P_CASH_SOB_ID
119: AND GJH.JE_BATCH_ID = GJB.JE_BATCH_ID
120: AND GJB.STATUS <> 'P';
121: SELECT_INTO_TABLE;

Line 167: , gl_je_batches gjb , gl_lookups l -- bug 6315298

163: , gjl.effective_date Effective_Date
164: , (nvl(gjl.accounted_dr,0) - nvl(gjl.accounted_cr,0)) Amount
165: FROM gl_period_statuses gls
166: -- , igi_com_gl_batches_copy_v jgb -- bug 6315298
167: , gl_je_batches gjb , gl_lookups l -- bug 6315298
168: , gl_code_combinations gcc
169: , gl_je_headers gjh
170: , gl_je_lines gjl
171: WHERE gjb.je_batch_id = gjh.je_batch_id

Line 202: , gl_je_batches gjb, gl_lookups l -- bug 6315298

198: , gjl.effective_date Effective_Date
199: , (nvl(gjl.accounted_dr,0) - nvl(gjl.accounted_cr,0)) Amount
200: FROM gl_period_statuses gls
201: -- , igi_com_gl_batches_copy_v jgb -- bug 6315298
202: , gl_je_batches gjb, gl_lookups l -- bug 6315298
203: , gl_code_combinations gcc
204: , gl_je_headers gjh
205: , gl_je_lines gjl
206: WHERE gjb.je_batch_id = gjh.je_batch_id