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 1357: from gl_period_statuses gps

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

Line 1365: select count(*) from gl_period_statuses gps

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