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 55: FROM GL_JE_HEADERS h

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

Line 76: FROM GL_JE_HEADERS h

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