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

Line 68: FROM gl_period_statuses gl1,

64: INTO
65: G_p_gl_end_date ,
66: G_coa_id ,
67: G_sob
68: FROM gl_period_statuses gl1,
69: pa_implementations_all imp1,
70: gl_sets_of_books sob1
71: WHERE
72: imp1.org_id = p_org_id

Line 1300: from gl_period_statuses

1296: into
1297: G_gl_period_name,
1298: G_gl_start_date,
1299: G_gl_end_date
1300: from gl_period_statuses
1301: where p_gl_date between START_DATE and END_DATE
1302: and adjustment_period_flag = 'N'
1303: and application_id = p_application_id
1304: and set_of_books_id = p_set_of_books_id;

Line 1343: from gl_period_statuses

1339: into
1340: G_gl_period_name,
1341: G_gl_start_date,
1342: G_gl_end_date
1343: from gl_period_statuses
1344: where p_gl_date between START_DATE and END_DATE
1345: and adjustment_period_flag = 'N'
1346: and application_id = 101 /* GL */
1347: and set_of_books_id = G_set_of_books_id;

Line 1378: from gl_period_statuses

1374: into
1375: G_gl_period_name,
1376: G_gl_start_date,
1377: G_gl_end_date
1378: from gl_period_statuses
1379: where period_name = p_gl_period_name
1380: and application_id = p_application_id
1381: and set_of_books_id = p_set_of_books_id;
1382:

Line 1401: from gl_period_statuses gl1 ,

1397: select
1398: to_char(gl1.start_date,'DD-MON-RR')
1399: into
1400: l_gl_start_date
1401: from gl_period_statuses gl1 ,
1402: pa_implementations imp1
1403: where gl1.period_name = p_gl_period_name
1404: and gl1.application_id = 101
1405: and gl1.set_of_books_id = imp1.set_of_books_id;