DBA Data[Home] [Help]

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 1282: , GL_PERIOD_STATUSES GLP

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

Line 1305: , GL_PERIOD_STATUSES GLP

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

Line 1471: FROM PA_PERIODS PAP, GL_PERIOD_STATUSES GLP,

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