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

Line 294: AND glh.period_name IN ( select distinct Period_name from gl_period_statuses where

290: ,gl_je_lines gll
291: ,gl_ledgers glg
292: ,gl_periods glp
293: WHERE glg.ledger_id IN (:P_LEDGER_ID)
294: AND glh.period_name IN ( select distinct Period_name from gl_period_statuses where
295: ledger_id = :P_LEDGER_ID and period_num <
296: (select distinct Period_num from gl_period_statuses
297: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)
298: and period_year in

Line 296: (select distinct Period_num from gl_period_statuses

292: ,gl_periods glp
293: WHERE glg.ledger_id IN (:P_LEDGER_ID)
294: AND glh.period_name IN ( select distinct Period_name from gl_period_statuses where
295: ledger_id = :P_LEDGER_ID and period_num <
296: (select distinct Period_num from gl_period_statuses
297: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)
298: and period_year in
299: (select distinct Period_year from gl_period_statuses
300: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)

Line 299: (select distinct Period_year from gl_period_statuses

295: ledger_id = :P_LEDGER_ID and period_num <
296: (select distinct Period_num from gl_period_statuses
297: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)
298: and period_year in
299: (select distinct Period_year from gl_period_statuses
300: where ledger_id = :P_LEDGER_ID and period_name = :P_PERIOD_FROM)
301: )
302: AND glh.ledger_id = glg.ledger_id
303: AND gll.je_header_id = glh.je_header_id

Line 2257: FROM gl_period_statuses

2253: -- Calculating Period Year Start and End Date. Bug 4755531- Use application_id 101
2254: -----------------------------------------------------------------------------------
2255: SELECT period_year
2256: INTO l_period_year
2257: FROM gl_period_statuses
2258: WHERE application_id = 101
2259: AND set_of_books_id = l_ledger_id
2260: AND period_name = p_period_from;
2261:

Line 2266: FROM gl_period_statuses

2262: SELECT TO_CHAR(MIN(start_date),'YYYY-MM-DD')
2263: ,TO_CHAR(MAX(end_date),'YYYY-MM-DD')
2264: INTO g_period_year_start_date
2265: ,g_period_year_end_date
2266: FROM gl_period_statuses
2267: WHERE application_id = 101
2268: AND set_of_books_id = l_ledger_id
2269: AND period_year = l_period_year
2270: AND adjustment_period_flag = 'N';