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 1280: FROM PA_TXN_ACCUM PTA

1276: ,GLP.END_DATE gl_end_date
1277: ,PTA.TOT_RAW_COST tot_raw_cost
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

Line 1302: FROM PA_TXN_ACCUM PTA

1298: ,PAP.END_DATE pa_end_date
1299: ,PTA.TOT_RAW_COST tot_raw_cost
1300: ,PTA.TOT_QUANTITY tot_quantity
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