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

Line 104: gl_period_statuses gps,

100: ja_cn_journal_lines jcjl,
101: ja_cn_cfs_assignments_all jccasa,
102: ja_cn_cfs_assign_sup_all jccasa1,
103: rg_reports rr,
104: gl_period_statuses gps,
105: ja_cn_voucher_number jcvn
106: --Update by Jianchao Chi, for cnaov2 upgrade 04-JAN-2011
107: --Add ja_cn_voucher_number table, voucher number and legal entity
108: --are fetched from ja_cn_voucher_number

Line 144: FROM gl_period_statuses

140: WHERE legal_entity_id = pn_legal_entity_id
141: AND ledger_id = pn_ledger_id)
142: AND jccaa.period_name IN
143: (SELECT period_name
144: FROM gl_period_statuses
145: WHERE ledger_id = pn_ledger_id
146: AND application_id = 101
147: AND ((start_date BETWEEN ld_start_date AND
148: ld_end_date) AND

Line 178: gl_period_statuses gps,

174: ja_cn_journal_lines jcjl,
175: ja_cn_cfs_assignments_all jccasa,
176: ja_cn_cfs_assign_sup_all jccasa1,
177: rg_reports rr,
178: gl_period_statuses gps,
179: ja_cn_voucher_number jcvn
180: --Update by Jianchao Chi, for cnaov2 upgrade 04-JAN-2011
181: --Add ja_cn_voucher_number table, voucher number and legal entity
182: --are fetched from ja_cn_voucher_number

Line 218: FROM gl_period_statuses

214: WHERE legal_entity_id = pn_legal_entity_id
215: AND ledger_id = pn_ledger_id)
216: AND jccaa.period_name IN
217: (SELECT period_name
218: FROM gl_period_statuses
219: WHERE ledger_id = pn_ledger_id
220: AND application_id = 101
221: AND ((start_date BETWEEN ld_start_date AND
222: ld_end_date) AND

Line 274: FROM GL_PERIOD_STATUSES

270: --Fetch start date and end date
271: IF pv_period_from IS NOT NULL THEN
272: SELECT start_date
273: INTO ld_start_date
274: FROM GL_PERIOD_STATUSES
275: WHERE ledger_id = pn_ledger_id
276: AND application_id = 101
277: AND period_name = pv_period_from
278: AND to_char(period_year) = pv_accounting_year;

Line 286: FROM GL_PERIOD_STATUSES

282:
283: IF pv_period_to IS NOT NULL THEN
284: SELECT end_date
285: INTO ld_end_date
286: FROM GL_PERIOD_STATUSES
287: WHERE ledger_id = pn_ledger_id
288: AND application_id = 101
289: AND period_name = pv_period_to
290: AND to_char(period_year) = pv_accounting_year;