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.GL_CASH_CLR_ACCT_ANAL_RPT_PKG dependencies on GL_PERIOD_STATUSES

Line 35: FROM gl_period_statuses gps

31: ,MAX(CASE gps.period_name
32: WHEN period_to_param THEN gps.effective_period_num END)
33: INTO gn_effective_period_num_from
34: ,gn_effective_period_num_to
35: FROM gl_period_statuses gps
36: WHERE gps.ledger_id = ledger_id_param
37: AND gps.application_id = 200
38: AND gps.period_name IN (period_from_param, period_to_param);
39:

Line 57: ,gl_period_statuses gps

53: ,xla_ae_lines xal
54: ,xla_ae_headers xah
55: ,xla_transaction_entities xte
56: ,ap_checks_all aca
57: ,gl_period_statuses gps
58: WHERE
59: gjl.ledger_id = :ledger_id_param
60: AND gjl.code_combination_id = :ccid
61: AND gps.ledger_id = gjl.ledger_id

Line 96: ,gl_period_statuses gps

92: ,xla_ae_lines xal
93: ,xla_ae_headers xah
94: ,xla_transaction_entities xte
95: ,ap_checks_all aca
96: ,gl_period_statuses gps
97: WHERE
98: gjl.ledger_id = :ledger_id_param
99: AND gjl.code_combination_id = :ccid
100: AND gps.ledger_id = gjl.ledger_id

Line 135: ,gl_period_statuses gps

131: FROM
132: gl_je_lines gjl
133: ,gl_je_headers gjh
134: ,gl_je_batches gjb
135: ,gl_period_statuses gps
136: WHERE
137: gjl.ledger_id = :ledger_id_param
138: AND gjl.code_combination_id = :ccid
139: AND gps.ledger_id = gjl.ledger_id

Line 173: ,gl_period_statuses gps

169: FROM
170: gl_je_lines gjl
171: ,gl_je_headers gjh
172: ,gl_je_batches gjb
173: ,gl_period_statuses gps
174: WHERE
175: gjl.ledger_id = :ledger_id_param
176: AND gjl.code_combination_id = :ccid
177: AND gps.ledger_id = gjl.ledger_id

Line 218: ,gl_period_statuses gps

214: ,xla_ae_lines xal
215: ,xla_ae_headers xah
216: ,xla_transaction_entities xte
217: ,ap_checks_all aca
218: ,gl_period_statuses gps
219: WHERE
220: gjl.ledger_id = :ledger_id_param
221: AND gjl.code_combination_id = :ccid
222: AND gps.ledger_id = gjl.ledger_id

Line 257: ,gl_period_statuses gps

253: ,xla_ae_lines xal
254: ,xla_ae_headers xah
255: ,xla_transaction_entities xte
256: ,ap_checks_all aca
257: ,gl_period_statuses gps
258: WHERE
259: gjl.ledger_id = :ledger_id_param
260: AND gjl.code_combination_id = :ccid
261: AND gps.ledger_id = gjl.ledger_id