APPS.GL_JE_LINES_RECON_PKG dependencies on GL_CODE_COMBINATIONS

Line 16: gl_code_combinations cc

12: SELECT jeh.je_header_id, jel.je_line_num, jeh.ledger_id,
13: sysdate, X_Last_Updated_By, sysdate,
14: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
15: FROM gl_je_batches jeb, gl_je_headers jeh, gl_ledgers lgr, gl_je_lines jel,
16: gl_code_combinations cc
17: WHERE jeb.je_batch_id = X_Je_Batch_Id
18: AND jeb.average_journal_flag = 'N'
19: AND jeh.je_batch_id = X_Je_Batch_Id
20: AND jeh.actual_flag = 'A'

Line 43: gl_code_combinations cc

39: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
40: sysdate, X_Last_Updated_By, sysdate,
41: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
42: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
43: gl_code_combinations cc
44: WHERE jeh.je_header_id = X_Je_Header_Id
45: AND jeh.actual_flag = 'A'
46: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')
47: AND jeb.je_batch_id = jeh.je_batch_id

Line 71: gl_code_combinations cc

67: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
68: sysdate, X_Last_Updated_By, sysdate,
69: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
70: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
71: gl_code_combinations cc
72: WHERE jeh.je_header_id = X_Je_Header_Id
73: AND jeh.actual_flag = 'A'
74: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')
75: AND jeb.je_batch_id = jeh.je_batch_id

Line 261: gl_code_combinations cc

257: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
258: sysdate, X_Last_Updated_By, sysdate,
259: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
260: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
261: gl_code_combinations cc
262: WHERE jeh.je_header_id = X_Je_Header_Id
263: AND jeh.actual_flag = 'A'
264: AND jeh.je_source NOT IN ('Move/Merge', 'Move/Merge Reversal')
265: AND jeh.display_alc_journal_flag IS NULL

Line 305: gl_code_combinations cc

301: SELECT jel.je_header_id, jel.je_line_num, jel.ledger_id,
302: sysdate, X_Last_Updated_By, sysdate,
303: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
304: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr, gl_je_lines jel,
305: gl_code_combinations cc
306: WHERE jeb.posting_run_id = X_Prun_Id
307: AND jeb.status = 'I'
308: AND jeb.average_journal_flag = 'N'
309: AND jeh.je_batch_id = jeb.je_batch_id

Line 351: gl_code_combinations cc

347: sysdate, X_Last_Updated_By, sysdate,
348: X_Last_Updated_By, X_Last_Update_Login, jeh.jgzz_recon_ref
349: FROM gl_je_headers jeh, gl_je_batches jeb, gl_ledgers lgr,
350: gl_je_batches sljeb, gl_je_headers sljeh, gl_je_lines sljel,
351: gl_code_combinations cc
352: WHERE jeb.posting_run_id = X_Prun_Id
353: AND jeb.status = 'I'
354: AND jeh.je_batch_id = jeb.je_batch_id
355: AND sljeh.parent_je_header_id = jeh.je_header_id