APPS.GL_CONS_BATCHES_PKG dependencies on GL_CONSOLIDATION

Line 40: from gl_cons_batches cb, gl_consolidation c,

36: AND h.period_name = X_Default_Period_Name
37: AND h.ledger_id = X_From_Ledger_Id
38: AND NOT EXISTS
39: (select 'X'
40: from gl_cons_batches cb, gl_consolidation c,
41: gl_consolidation_history ch
42: where c.consolidation_id = cb.consolidation_id
43: and c.to_ledger_id = X_To_Ledger_Id
44: and cb.je_batch_id = h.je_batch_id

Line 41: gl_consolidation_history ch

37: AND h.ledger_id = X_From_Ledger_Id
38: AND NOT EXISTS
39: (select 'X'
40: from gl_cons_batches cb, gl_consolidation c,
41: gl_consolidation_history ch
42: where c.consolidation_id = cb.consolidation_id
43: and c.to_ledger_id = X_To_Ledger_Id
44: and cb.je_batch_id = h.je_batch_id
45: and ch.consolidation_run_id = cb.consolidation_run_id

Line 62: from gl_cons_batches cb, gl_consolidation c,

58: AND period_name = X_Default_Period_Name
59: AND h.ledger_id = X_From_Ledger_Id
60: AND EXISTS
61: (select 'X'
62: from gl_cons_batches cb, gl_consolidation c,
63: gl_consolidation_history ch
64: where c.consolidation_id = cb.consolidation_id
65: and c.to_ledger_id = X_To_Ledger_Id
66: and cb.je_batch_id = h.je_batch_id

Line 63: gl_consolidation_history ch

59: AND h.ledger_id = X_From_Ledger_Id
60: AND EXISTS
61: (select 'X'
62: from gl_cons_batches cb, gl_consolidation c,
63: gl_consolidation_history ch
64: where c.consolidation_id = cb.consolidation_id
65: and c.to_ledger_id = X_To_Ledger_Id
66: and cb.je_batch_id = h.je_batch_id
67: and ch.consolidation_run_id = cb.consolidation_run_id