eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_ACCT_ANALYSIS_RPT_PKG dependencies on GL_PERIOD_STATUSES

Line 533: FROM gl_period_statuses

529: SELECT effective_period_num
530: ,START_DATE
531: INTO l_start_period_num
532: ,l_start_date
533: FROM gl_period_statuses
534: WHERE application_id = 101
535: AND ledger_id = l_ledger_id
536: AND period_name = p_period_from;
537:

Line 542: FROM gl_period_statuses

538: SELECT effective_period_num
539: ,end_date
540: INTO l_end_period_num
541: ,l_end_date
542: FROM gl_period_statuses
543: WHERE application_id = 101
544: AND ledger_id = l_ledger_id
545: AND period_name = p_period_to;
546:

Line 1473: ,gl_period_statuses gls

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
1477: AND gll.ledger_id IN $ledger_id$