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_ACCUM_UTILS dependencies on GL_PERIOD_STATUSES

Line 255: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,

251: x_current_pa_end_date,
252: x_current_gl_start_date,
253: x_current_gl_end_date,
254: x_current_year
255: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,
256: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL
257: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
258: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
259: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id

Line 487: GL_PERIOD_STATUSES gps, pa_implementations imp

483: DISTINCT YEAR_START_DATE
484: INTO
485: x_period_yr_start_date
486: FROM
487: GL_PERIOD_STATUSES gps, pa_implementations imp
488: WHERE gps.application_id = pa_period_process_pkg.application_id
489: and gps.set_of_books_id = imp.set_of_books_id
490: and gps.period_name = x_current_gl_period;
491:

Line 1257: , GL_PERIOD_STATUSES GLP

1253: ,PTA.TOT_REVENUE tot_revenue
1254: FROM PA_TXN_ACCUM PTA
1255: , PA_RESOURCE_ACCUM_DETAILS PRAD
1256: , PA_PERIODS PAP
1257: , GL_PERIOD_STATUSES GLP
1258: , PA_IMPLEMENTATIONS PAIMP
1259: WHERE PRAD.PROJECT_ID = x_project_id
1260: AND PRAD.RESOURCE_LIST_ID = x_resource_list_id
1261: AND PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID

Line 1283: , GL_PERIOD_STATUSES GLP

1279: ,PTA.TOT_QUANTITY tot_quantity
1280: ,PTA.TOT_REVENUE tot_revenue
1281: FROM PA_TXN_ACCUM PTA
1282: , PA_RESOURCE_ACCUM_DETAILS PRAD
1283: , GL_PERIOD_STATUSES GLP
1284: , PA_IMPLEMENTATIONS PAIMP
1285: WHERE PRAD.PROJECT_ID = x_project_id
1286: AND PRAD.RESOURCE_LIST_ID = x_resource_list_id
1287: AND PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID

Line 1307: , GL_PERIOD_STATUSES GLP

1303: ,PTA.TOT_REVENUE tot_revenue
1304: FROM PA_TXN_ACCUM PTA
1305: , PA_RESOURCE_ACCUM_DETAILS PRAD
1306: , PA_PERIODS PAP
1307: , GL_PERIOD_STATUSES GLP
1308: , PA_IMPLEMENTATIONS PAIMP
1309: WHERE PRAD.PROJECT_ID = x_project_id
1310: AND PRAD.RESOURCE_LIST_ID = x_resource_list_id
1311: AND PRAD.TXN_ACCUM_ID = PTA.TXN_ACCUM_ID

Line 1475: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,

1471: -- where current_pa_period_flag = 'Y';
1472: select decode(paimp.accumulation_period_type, 'PA', pap.end_date,
1473: 'GL', glp.end_date)
1474: into lcl_end_date
1475: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,
1476: PA_IMPLEMENTATIONS PAIMP, PA_LOOKUPS PAL
1477: WHERE PAP.GL_PERIOD_NAME = GLP.PERIOD_NAME
1478: AND GLP.SET_OF_BOOKS_ID = PAIMP.SET_OF_BOOKS_ID
1479: AND GLP.APPLICATION_ID = Pa_Period_Process_Pkg.Application_id