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

Line 2468: , gl_period_statuses glps

2464: SELECT MIN(TIM.start_date) first_open
2465: INTO l_report_date
2466: FROM
2467: pji_time_cal_period_v TIM
2468: , gl_period_statuses glps
2469: , pa_implementations paimp
2470: WHERE 1=1
2471: AND TIM.calendar_id = x_calendar_id
2472: AND paimp.set_of_books_id = glps.set_of_books_id

Line 2481: , gl_period_statuses glps

2477: SELECT MAX(TIM.start_date) last_open
2478: INTO l_report_date
2479: FROM
2480: pji_time_cal_period_v TIM
2481: , gl_period_statuses glps
2482: , pa_implementations paimp
2483: WHERE 1=1
2484: AND TIM.calendar_id = x_calendar_id
2485: AND paimp.set_of_books_id = glps.set_of_books_id

Line 2494: , gl_period_statuses glps

2490: SELECT MAX(TIM.start_date) last_closed
2491: INTO l_report_date
2492: FROM
2493: pji_time_cal_period_v TIM
2494: , gl_period_statuses glps
2495: , pa_implementations paimp
2496: WHERE 1=1
2497: AND TIM.calendar_id = x_calendar_id
2498: AND paimp.set_of_books_id = glps.set_of_books_id