DBA Data[Home] [Help]

APPS.IGI_IGIGCBGD_XMLP_PKG dependencies on GL_JE_HEADERS

Line 116: GL_JE_HEADERS GJH,

112: SELECT
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';

Line 169: , gl_je_headers gjh

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
172: and l.lookup_type = ''BATCH_TYPE'' -- bug 6315298
173: and l.lookup_code = gjb.actual_flag -- bug 6315298

Line 204: , gl_je_headers gjh

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
207: and l.lookup_type = ''BATCH_TYPE'' -- bug 6315298
208: and l.lookup_code = gjb.actual_flag and gjb.status = ''P'' -- bug 6315298