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: --
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:
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