DBA Data[Home] [Help]

APPS.XLA_ACCT_ANALYSIS_RPT_PKG dependencies on GL_LEDGERS

Line 501: FROM gl_ledgers

497: -- Identifying ledger as Ledger or Ledger Set and get value for language
498: --
499: SELECT object_type_code, USERENV('LANG')
500: INTO l_object_type, l_lang
501: FROM gl_ledgers
502: WHERE ledger_id = p_ledger_id;
503:
504:
505: --

Line 564: FROM gl_ledgers

560: --
561:
562: SELECT chart_of_accounts_id
563: INTO l_coa_id
564: FROM gl_ledgers
565: WHERE ledger_id = p_ledger_id;
566:
567: -- Get concatenated segment
568:

Line 1472: FROM gl_ledgers gll

1468: ,gll.chart_of_accounts_id
1469: ,gls.period_name
1470: ,gls.start_date
1471: ,gls.end_date
1472: FROM gl_ledgers gll
1473: ,gl_period_statuses gls
1474: WHERE gls.ledger_id = gll.ledger_id
1475: AND gls.application_id = 101
1476: AND gls.effective_period_num BETWEEN :P_START_PERIOD_NUM AND :P_END_PERIOD_NUM