DBA Data[Home] [Help]

APPS.XLA_JELINES_RPT_PKG dependencies on GL_LEDGERS

Line 291: ,gl_ledgers glg

287: ,nvl(sum(nvl(gll.accounted_cr,0)),0) YTD_ACTIVITY_CR
288: FROM
289: gl_je_headers glh
290: ,gl_je_lines gll
291: ,gl_ledgers glg
292: ,gl_periods glp
293: WHERE glg.ledger_id IN (:P_LEDGER_ID)
294: AND glh.period_name IN ( select distinct Period_name from gl_period_statuses where
295: ledger_id = :P_LEDGER_ID and period_num <

Line 904: ,gl_ledgers glg

900: ,xla_event_classes_tl xect
901: ,xla_event_types_tl xet
902: ,fnd_user fdu
903: ,xla_transaction_entities ent
904: ,gl_ledgers glg
905: ,gl_periods glp
906: ,fnd_application_tl fap
907: ,gl_budget_versions glb
908: ,gl_encumbrance_types get

Line 1782: ,gl_ledgers glg

1778: p_gl_from :=
1779: 'FROM
1780: gl_je_headers glh
1781: ,gl_je_lines gll
1782: ,gl_ledgers glg
1783: ,xla_lookups xlk
1784: ,gl_lookups glk2
1785: ,gl_budget_versions gbv
1786: ,fnd_user fdu

Line 2231: FROM gl_ledgers

2227: -- Identifying ledger as Ledger or Ledger Set
2228: --
2229: SELECT object_type_code
2230: INTO l_object_type
2231: FROM gl_ledgers
2232: WHERE ledger_id = p_ledger_id;
2233:
2234: IF l_object_type = 'S' THEN
2235: l_ledgers := '(SELECT ledger_id '||