DBA Data[Home] [Help]

APPS.GL_CONS_BATCHES_PKG dependencies on GL_JE_HEADERS

Line 33: FROM GL_JE_HEADERS h

29: (consolidation_id, consolidation_run_id, je_batch_id,
30: last_update_date, last_updated_by)
31: SELECT DISTINCT X_Consolidation_Id, X_Consolidation_Run_Id,
32: h.je_batch_id, sysdate, X_Last_Updated_By
33: FROM GL_JE_HEADERS h
34: WHERE h.status = 'P'
35: AND h.ACTUAL_FLAG = 'A'
36: AND h.period_name = X_Default_Period_Name
37: AND h.ledger_id = X_From_Ledger_Id

Line 56: FROM GL_JE_HEADERS h

52: last_update_date, last_updated_by)
53: SELECT DISTINCT
54: X_Consolidation_Id, X_Consolidation_Run_Id, h.je_batch_id,
55: sysdate, X_Last_Updated_By
56: FROM GL_JE_HEADERS h
57: WHERE status = 'P'
58: AND ACTUAL_FLAG = 'A'
59: AND period_name = X_Default_Period_Name
60: AND h.ledger_id = X_From_Ledger_Id

Line 78: FROM GL_JE_HEADERS h

74: last_update_date, last_updated_by)
75: SELECT DISTINCT
76: X_Consolidation_Id, X_Consolidation_Run_Id, h.je_batch_id,
77: sysdate, X_Last_Updated_By
78: FROM GL_JE_HEADERS h
79: WHERE status = 'P'
80: AND ACTUAL_FLAG = 'A'
81: AND period_name = X_Default_Period_Name
82: AND h.ledger_id = X_From_Ledger_Id;