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 1160: FROM gl_period_statuses gps

1156: , period_year
1157: , closing_status
1158: , start_date
1159: , end_date -- 4262811
1160: FROM gl_period_statuses gps
1161: WHERE gps.application_id = 101
1162: AND gps.ledger_id = aeh.ledger_id
1163: AND gps.adjustment_period_flag = 'N'
1164: AND aeh.ACCOUNTING_DATE BETWEEN gps.start_date AND gps.end_date)

Line 1191: FROM gl_period_statuses gps

1187: --
1188: UPDATE xla_ae_headers_gt xah
1189: SET first_day_next_gl_period =
1190: (SELECT min(gps.start_date)
1191: FROM gl_period_statuses gps
1192: WHERE gps.application_id = 101
1193: AND gps.ledger_id = xah.ledger_id
1194: AND gps.adjustment_period_flag = 'N'
1195: AND gps.closing_status = 'O'

Line 1232: , gl_period_statuses gps

1228: , NVL(gps.closing_status, xah.period_closing_status)
1229: , NVL(gps.start_date, xah.period_start_date)
1230: , NVL(gps.end_date, xah.period_end_date)
1231: FROM xla_ae_headers_gt xah2
1232: , gl_period_statuses gps
1233: WHERE xah.ae_header_id = xah2.ae_header_id
1234: AND gps.application_id (+) = 101
1235: AND gps.ledger_id (+) = xah2.ledger_id
1236: AND gps.adjustment_period_flag (+) = 'N'