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_ACCOUNTING_ENGINE_PKG dependencies on GL_PERIOD_STATUSES

Line 1134: FROM gl_period_statuses gps

1130: , period_year
1131: , closing_status
1132: , start_date
1133: , end_date -- 4262811
1134: FROM gl_period_statuses gps
1135: WHERE gps.application_id = 101
1136: AND gps.ledger_id = aeh.ledger_id
1137: AND gps.adjustment_period_flag = 'N'
1138: AND aeh.ACCOUNTING_DATE BETWEEN gps.start_date AND gps.end_date)

Line 1165: FROM gl_period_statuses gps

1161: --
1162: UPDATE xla_ae_headers_gt xah
1163: SET first_day_next_gl_period =
1164: (SELECT min(gps.start_date)
1165: FROM gl_period_statuses gps
1166: WHERE gps.application_id = 101
1167: AND gps.ledger_id = xah.ledger_id
1168: AND gps.adjustment_period_flag = 'N'
1169: AND gps.closing_status = 'O'

Line 1206: , gl_period_statuses gps

1202: , NVL(gps.closing_status, xah.period_closing_status)
1203: , NVL(gps.start_date, xah.period_start_date)
1204: , NVL(gps.end_date, xah.period_end_date)
1205: FROM xla_ae_headers_gt xah2
1206: , gl_period_statuses gps
1207: WHERE xah.ae_header_id = xah2.ae_header_id
1208: AND gps.application_id (+) = 101
1209: AND gps.ledger_id (+) = xah2.ledger_id
1210: AND gps.adjustment_period_flag (+) = 'N'