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

Line 1356: from gl_period_statuses gps

1352: where x_date between pap.start_date and pap.end_date ;
1353:
1354: cursor c_gl_period(x_date date) is
1355: select 1
1356: from gl_period_statuses gps
1357: where x_date between gps.start_date
1358: and gps.end_date
1359: and gps.application_id = 101
1360: and gps.set_of_books_id = (select set_of_books_id

Line 1364: select count(*) from gl_period_statuses gps

1360: and gps.set_of_books_id = (select set_of_books_id
1361: from pa_implementations);
1362:
1363: /* Bug# 3985020 : Commented
1364: select count(*) from gl_period_statuses gps
1365: where x_date between gps.start_date and gps.end_date
1366: and gps.application_id = 101
1367: and gps.set_of_books_id in (select set_of_books_id from pa_implementations_all);
1368: */