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

Line 1705: GL_PERIOD_STATUSES gps

1701: XLA_AE_HEADERS aeh,
1702: JA_CN_CODE_COMBINATION_V jcc,
1703: HZ_CUST_ACCOUNTS cust,
1704: HZ_PARTIES part,
1705: GL_PERIOD_STATUSES gps
1706: WHERE jeh.je_header_id = jel.je_header_id
1707: AND jeh.je_header_id = gir.je_header_id
1708: AND jel.je_line_num = gir.je_line_num
1709: AND gir.gl_sl_link_id = ael.gl_sl_link_id

Line 2493: FROM GL_PERIOD_STATUSES

2489: IF pv_period_from IS NOT NULL
2490: THEN
2491: SELECT start_date
2492: INTO ld_start_date
2493: FROM GL_PERIOD_STATUSES
2494: WHERE ledger_id = pn_ledger_id
2495: AND application_id = 101
2496: AND period_name = pv_period_from
2497: AND to_char(period_year) = pv_accounting_year;

Line 2506: FROM GL_PERIOD_STATUSES

2502: IF pv_period_to IS NOT NULL
2503: THEN
2504: SELECT end_date
2505: INTO ld_end_date
2506: FROM GL_PERIOD_STATUSES
2507: WHERE ledger_id = pn_ledger_id
2508: AND application_id = 101
2509: AND period_name = pv_period_to
2510: AND to_char(period_year) = pv_accounting_year;