DBA Data[Home] [Help]

APPS.PA_ACCUM_UTILS dependencies on PA_TXN_ACCUM

Line 1210: -- for the first pa_txn_accum period

1206:
1207: --Name: Get_First_Accum_Period
1208: --Type: Procedure
1209: --Description: This procedure fetches attributes
1210: -- for the first pa_txn_accum period
1211: -- for a project and resource list.
1212: --
1213: --Called subprograms: none
1214: --

Line 1254: FROM PA_TXN_ACCUM PTA

1250: ,GLP.END_DATE gl_end_date
1251: ,PTA.TOT_RAW_COST tot_raw_cost
1252: ,PTA.TOT_QUANTITY tot_quantity
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

Line 1281: FROM PA_TXN_ACCUM PTA

1277: ,PTA.TOT_RAW_COST tot_raw_cost
1278: ,PTA.TOT_BURDENED_COST tot_burd_cost --Bug 10029571
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

Line 1304: FROM PA_TXN_ACCUM PTA

1300: ,PTA.TOT_RAW_COST tot_raw_cost
1301: ,PTA.TOT_BURDENED_COST tot_burd_cost --Bug 10029571
1302: ,PTA.TOT_QUANTITY tot_quantity
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