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 372: gl_sets_of_books gl,

368:
369: SELECT glper.period_name,glper.period_year,gllkups.meaning
370: INTO l_prd_name,l_prd_yr,l_meaning
371: FROM pa_implementations imp,
372: gl_sets_of_books gl,
373: gl_periods glper,
374: gl_period_statuses glst,
375: gl_lookups gllkups
376: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 484: gl_sets_of_books gl,

480: ELSIF ( l_period_type = 'QR') THEN
481: SELECT glper.quarter_num
482: INTO l_quarter_num
483: FROM pa_implementations imp,
484: gl_sets_of_books gl,
485: gl_periods glper,
486: gl_period_statuses glst
487: WHERE imp.set_of_books_id = gl.set_of_books_id
488: AND gl.period_set_name = glper.period_set_name

Line 978: gl_sets_of_books gl,

974: x_msg_data OUT NOCOPY VARCHAR2) IS
975:
976: /* CURSOR C1 IS SELECT glper.period_name,glper.period_year,glst.closing_status,glper.quarter_num,glst.effective_period_num
977: FROM pa_implementations imp,
978: gl_sets_of_books gl,
979: gl_periods glper,
980: gl_period_statuses glst
981: WHERE imp.set_of_books_id = gl.set_of_books_id
982: AND gl.period_set_name = glper.period_set_name

Line 1018: gl_sets_of_books gl,

1014: ,glper.quarter_num
1015: ,glst.effective_period_num
1016: ,gllkups.meaning
1017: FROM pa_implementations imp,
1018: gl_sets_of_books gl,
1019: gl_periods glper,
1020: gl_period_statuses glst,
1021: gl_lookups gllkups
1022: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 1330: gl_sets_of_books gl,

1326: ,glst.effective_period_num
1327: ,gllkups.meaning
1328: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1329: FROM pa_implementations imp,
1330: gl_sets_of_books gl,
1331: gl_periods glper,
1332: gl_period_statuses glst,
1333: gl_lookups gllkups
1334: WHERE imp.set_of_books_id = gl.set_of_books_id

Line 1489: gl_sets_of_books gl,

1485: ,glst.effective_period_num
1486: ,gllkups.meaning
1487: INTO l_prd_name,l_prd_yr,l_sts,l_mon_qtr,l_period_num,l_sts_meaning
1488: FROM pa_implementations imp,
1489: gl_sets_of_books gl,
1490: gl_periods glper,
1491: gl_period_statuses glst,
1492: gl_lookups gllkups
1493: WHERE imp.set_of_books_id = gl.set_of_books_id