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_REPORT_UTIL dependencies on GL_SETS_OF_BOOKS

Line 405: gl_sets_of_books gl,

401:
402: SELECT glper.period_name,glper.period_year,gllkups.meaning
403: INTO l_prd_name,l_prd_yr,l_meaning
404: FROM pa_implementations imp,
405: gl_sets_of_books gl,
406: gl_periods glper,
407: gl_period_statuses glst,
408: gl_lookups gllkups
409: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 517: gl_sets_of_books gl,

513: ELSIF ( l_period_type = 'QR') THEN
514: SELECT glper.quarter_num
515: INTO l_quarter_num
516: FROM pa_implementations imp,
517: gl_sets_of_books gl,
518: gl_periods glper,
519: gl_period_statuses glst
520: WHERE imp.set_of_books_id = gl.set_of_books_id
521: AND gl.period_set_name = glper.period_set_name

Line 1011: gl_sets_of_books gl,

1007: x_msg_data OUT NOCOPY VARCHAR2) IS
1008:
1009: /* CURSOR C1 IS SELECT glper.period_name,glper.period_year,glst.closing_status,glper.quarter_num,glst.effective_period_num
1010: FROM pa_implementations imp,
1011: gl_sets_of_books gl,
1012: gl_periods glper,
1013: gl_period_statuses glst
1014: WHERE imp.set_of_books_id = gl.set_of_books_id
1015: AND gl.period_set_name = glper.period_set_name

Line 1054: gl_sets_of_books gl,

1050: ,glper.quarter_num
1051: ,glst.effective_period_num
1052: ,gllkups.meaning
1053: FROM pa_implementations imp,
1054: gl_sets_of_books gl,
1055: gl_periods glper,
1056: gl_period_statuses glst,
1057: gl_lookups gllkups
1058: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 1378: gl_sets_of_books gl,

1374: ,glst.effective_period_num
1375: ,gllkups.meaning
1376: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1377: FROM pa_implementations imp,
1378: gl_sets_of_books gl,
1379: gl_periods glper,
1380: gl_period_statuses glst,
1381: gl_lookups gllkups
1382: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 1552: gl_sets_of_books gl,

1548: ,glst.effective_period_num
1549: ,gllkups.meaning
1550: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1551: FROM pa_implementations imp,
1552: gl_sets_of_books gl,
1553: gl_periods glper,
1554: gl_period_statuses glst,
1555: gl_lookups gllkups
1556: WHERE imp.set_of_books_id = gl.set_of_books_id