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 2870: , gl_period_statuses glps

2866: SELECT MIN(TIM.start_date) first_open
2867: INTO l_report_date
2868: FROM
2869: pji_time_cal_period_v TIM
2870: , gl_period_statuses glps
2871: , pa_implementations paimp
2872: WHERE 1=1
2873: AND TIM.calendar_id = x_calendar_id
2874: AND paimp.set_of_books_id = glps.set_of_books_id

Line 2897: , gl_period_statuses glps

2893: SELECT MAX(TIM.start_date) last_open
2894: INTO l_report_date
2895: FROM
2896: pji_time_cal_period_v TIM
2897: , gl_period_statuses glps
2898: , pa_implementations paimp
2899: WHERE 1=1
2900: AND TIM.calendar_id = x_calendar_id
2901: AND paimp.set_of_books_id = glps.set_of_books_id

Line 2924: , gl_period_statuses glps

2920: SELECT MAX(TIM.start_date) last_closed
2921: INTO l_report_date
2922: FROM
2923: pji_time_cal_period_v TIM
2924: , gl_period_statuses glps
2925: , pa_implementations paimp
2926: WHERE 1=1
2927: AND TIM.calendar_id = x_calendar_id
2928: AND paimp.set_of_books_id = glps.set_of_books_id