APPS.PA_PROCESS_ACCUM_ACTUALS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 47

     Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD               = RAW_COST_ITD + X_Raw_Cost,
         RAW_COST_YTD               = RAW_COST_YTD + X_Raw_Cost,
         RAW_COST_PTD               = RAW_COST_PTD + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD      = BILLABLE_RAW_COST_ITD +
                                      X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_YTD      = BILLABLE_RAW_COST_YTD +
                                      X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_PTD      = BILLABLE_RAW_COST_PTD +
                                      X_Billable_Raw_Cost,
         BURDENED_COST_ITD          = BURDENED_COST_ITD + X_Burdened_Cost,
         BURDENED_COST_YTD          = BURDENED_COST_YTD + X_Burdened_Cost,
         BURDENED_COST_PTD          = BURDENED_COST_PTD + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD = BILLABLE_BURDENED_COST_ITD +
                                      X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_YTD = BILLABLE_BURDENED_COST_YTD +
                                      X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_PTD = BILLABLE_BURDENED_COST_PTD +
                                      X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD            = LABOR_HOURS_ITD + X_Labor_Hours,
         LABOR_HOURS_YTD            = LABOR_HOURS_YTD + X_Labor_Hours,
         LABOR_HOURS_PTD            = LABOR_HOURS_PTD + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD   = BILLABLE_LABOR_HOURS_ITD +
                                      X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_YTD   = BILLABLE_LABOR_HOURS_YTD +
                                      X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_PTD   = BILLABLE_LABOR_HOURS_PTD +
                                      X_Billable_Labor_Hours,
         LAST_UPDATED_BY            = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE           = Trunc(Sysdate),
         LAST_UPDATE_LOGIN          = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)  UNION
         select  to_number(X_Proj_accum_id) from sys.dual);

Line: 92

     Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                = REVENUE_ITD + X_Revenue,
         REVENUE_YTD                = REVENUE_YTD + X_Revenue,
         REVENUE_PTD                = REVENUE_PTD + X_Revenue,
         LAST_UPDATED_BY            = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE           = Trunc(Sysdate),
         LAST_UPDATE_LOGIN          = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id) UNION
         select  to_number(X_Proj_accum_id) from sys.dual);

Line: 160

        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD                 = RAW_COST_ITD + X_Raw_Cost,
         RAW_COST_YTD                 = RAW_COST_YTD + X_Raw_Cost,
         RAW_COST_PP                  = RAW_COST_PP + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD        = BILLABLE_RAW_COST_ITD +
                                        X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_YTD        = BILLABLE_RAW_COST_YTD +
                                        X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_PP         = BILLABLE_RAW_COST_PP +
                                        X_Billable_Raw_Cost,
         BURDENED_COST_ITD            = BURDENED_COST_ITD + X_Burdened_Cost,
         BURDENED_COST_YTD            = BURDENED_COST_YTD + X_Burdened_Cost,
         BURDENED_COST_PP             = BURDENED_COST_PP + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD   = BILLABLE_BURDENED_COST_ITD +
                                        X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_YTD   = BILLABLE_BURDENED_COST_YTD +
                                        X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_PP    = BILLABLE_BURDENED_COST_PP +
                                        X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD              = LABOR_HOURS_ITD + X_Labor_Hours,
         LABOR_HOURS_YTD              = LABOR_HOURS_YTD + X_Labor_Hours,
         LABOR_HOURS_PP               = LABOR_HOURS_PP + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD     = BILLABLE_LABOR_HOURS_ITD +
                                        X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_YTD     = BILLABLE_LABOR_HOURS_YTD +
                                        X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_PP      = BILLABLE_LABOR_HOURS_PP +
                                        X_Billable_Labor_Hours,
         LAST_UPDATED_BY              = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE             = Trunc(Sysdate),
         LAST_UPDATE_LOGIN            = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)
         UNION select  to_number(X_Proj_accum_id) from sys.dual);

Line: 204

        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                  = REVENUE_ITD + X_Revenue,
         REVENUE_YTD                  = REVENUE_YTD + X_Revenue,
         REVENUE_PP                   = REVENUE_PP + X_Revenue,
         LAST_UPDATED_BY              = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE             = Trunc(Sysdate),
         LAST_UPDATE_LOGIN            = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)
         UNION select  to_number(X_Proj_accum_id) from sys.dual);

Line: 273

        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD               = RAW_COST_ITD + X_Raw_Cost,
         RAW_COST_PP                = RAW_COST_PP + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD      = BILLABLE_RAW_COST_ITD +
                                      X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_PP       = BILLABLE_RAW_COST_PP +
                                      X_Billable_Raw_Cost,
         BURDENED_COST_ITD          = BURDENED_COST_ITD + X_Burdened_Cost,
         BURDENED_COST_PP           = BURDENED_COST_PP + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD = BILLABLE_BURDENED_COST_ITD +
                                      X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_PP  = BILLABLE_BURDENED_COST_PP +
                                      X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD            = LABOR_HOURS_ITD + X_Labor_Hours,
         LABOR_HOURS_PP             = LABOR_HOURS_PP + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD   = BILLABLE_LABOR_HOURS_ITD +
                                      X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_PP    = BILLABLE_LABOR_HOURS_PP +
                                      X_Billable_Labor_Hours,
         LAST_UPDATED_BY            = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE           = Trunc(Sysdate),
         LAST_UPDATE_LOGIN          = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)
         UNION select  to_number(X_Proj_accum_id) from sys.dual);

Line: 308

        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                = REVENUE_ITD + X_Revenue,
         REVENUE_PP                 = REVENUE_PP + X_Revenue,
         LAST_UPDATED_BY            = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE           = Trunc(Sysdate),
         LAST_UPDATE_LOGIN          = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)
         UNION select  to_number(X_Proj_accum_id) from sys.dual);

Line: 376

        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD               = RAW_COST_ITD + X_Raw_Cost,
         RAW_COST_YTD               = RAW_COST_YTD + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD      = BILLABLE_RAW_COST_ITD +
                                      X_Billable_Raw_Cost,
         BILLABLE_RAW_COST_YTD      = BILLABLE_RAW_COST_YTD +
                                      X_Billable_Raw_Cost,
         BURDENED_COST_ITD          = BURDENED_COST_ITD + X_Burdened_Cost,
         BURDENED_COST_YTD          = BURDENED_COST_YTD + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD = BILLABLE_BURDENED_COST_ITD +
                                      X_Billable_Burdened_Cost,
         BILLABLE_BURDENED_COST_YTD = BILLABLE_BURDENED_COST_YTD +
                                      X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD            = LABOR_HOURS_ITD + X_Labor_Hours,
         LABOR_HOURS_YTD            = LABOR_HOURS_YTD + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD   = BILLABLE_LABOR_HOURS_ITD +
                                      X_Billable_Labor_Hours,
         BILLABLE_LABOR_HOURS_YTD   = BILLABLE_LABOR_HOURS_YTD +
                                      X_Billable_Labor_Hours,
         LAST_UPDATED_BY            = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE           = Trunc(Sysdate),
         LAST_UPDATE_LOGIN          = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)
         UNION select  to_number(X_Proj_accum_id) from sys.dual);

Line: 410

        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                = REVENUE_ITD + X_Revenue,
         REVENUE_YTD                = REVENUE_YTD + X_Revenue,
         LAST_UPDATED_BY            = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE           = Trunc(Sysdate),
         LAST_UPDATE_LOGIN          = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)
         UNION select  to_number(X_Proj_accum_id) from sys.dual);

Line: 479

        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         RAW_COST_ITD               = RAW_COST_ITD + X_Raw_Cost,
         BILLABLE_RAW_COST_ITD      = BILLABLE_RAW_COST_ITD +
                                      X_Billable_Raw_Cost,
         BURDENED_COST_ITD          = BURDENED_COST_ITD + X_Burdened_Cost,
         BILLABLE_BURDENED_COST_ITD = BILLABLE_BURDENED_COST_ITD +
                                      X_Billable_Burdened_Cost,
         LABOR_HOURS_ITD            = LABOR_HOURS_ITD + X_Labor_Hours,
         BILLABLE_LABOR_HOURS_ITD   = BILLABLE_LABOR_HOURS_ITD +
                                      X_Billable_Labor_Hours,
         LAST_UPDATED_BY            = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE           = Trunc(Sysdate),
         LAST_UPDATE_LOGIN          = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)
         UNION select  to_number(X_Proj_accum_id) from sys.dual);

Line: 505

        Update PA_PROJECT_ACCUM_ACTUALS  PAA SET
         REVENUE_ITD                = REVENUE_ITD + X_Revenue,
         LAST_UPDATED_BY            = pa_proj_accum_main.x_last_updated_by,
         LAST_UPDATE_DATE           = Trunc(Sysdate),
         LAST_UPDATE_LOGIN          = pa_proj_accum_main.x_last_update_login
         Where PAA.Project_Accum_id     In
        (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
         Where Pah.Project_id = x_project_id and
         pah.Resource_list_member_id = 0 and
         Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
         start with pt.task_id = x_task_id
         connect by prior pt.parent_task_id = pt.task_id)
         UNION select  to_number(X_Proj_accum_id) from sys.dual);