DBA Data[Home] [Help]

APPS.XLA_ACCT_ANALYSIS_RPT_PKG dependencies on GL_LEDGERS

Line 643: FROM gl_ledgers

639: -- Identifying ledger as Ledger or Ledger Set and get value for language
640: --
641: SELECT object_type_code, USERENV('LANG')
642: INTO l_object_type, l_lang
643: FROM gl_ledgers
644: WHERE ledger_id = p_ledger_id;
645:
646:
647: --

Line 712: FROM gl_ledgers

708: --
709:
710: SELECT chart_of_accounts_id
711: INTO l_coa_id
712: FROM gl_ledgers
713: WHERE ledger_id = p_ledger_id;
714:
715: -- Get concatenated segment
716:

Line 2140: FROM gl_ledgers gll

2136: ,gll.chart_of_accounts_id
2137: ,gls.period_name
2138: ,gls.start_date
2139: ,gls.end_date
2140: FROM gl_ledgers gll
2141: ,gl_period_statuses gls
2142: WHERE gls.ledger_id = gll.ledger_id
2143: AND gls.application_id = 101
2144: AND gls.effective_period_num BETWEEN :P_START_PERIOD_NUM AND :P_END_PERIOD_NUM