APPS.PA_WORK_TYPE_UPGRADE dependencies on PA_TASKS

Line 8: pa_tasks,

4: /* Procedure: Upgrade_WT_Main
5:
6: Updates Work Type Id on
7: pa_projects_all,
8: pa_tasks,
9: pa_expenditure_items_all,
10: pa_cost_distribution_lines_all
11:
12: Simultaneously, it also updates Tp Amt Type Code on

Line 161: update pa_tasks

157: --dbms_output.PUT_LINE('No of Project Records updated = '||l_rowcount);
158: --Code Changes for Bug No.2984871 end
159:
160: FORALL i in l_PrjIdTab.first .. l_PrjIdTab.last
161: update pa_tasks
162: set work_type_id = l_WorkTypeTab(i)
163: where project_id = l_PrjIdTab(i)
164: and work_type_id is null;
165:

Line 536: Pa_Tasks Tsk,

532: Select Temp.Pk1_Id,
533: Tsk.Work_Type_Id,
534: Wt.Tp_Amt_Type_Code
535: From pa_txn_upgrade_temp Temp,
536: Pa_Tasks Tsk,
537: Pa_Work_Types_B Wt
538: Where Worker_Id = p_worker_id
539: And Temp.Pk2_id = Tsk.Task_Id
540: And Tsk.Work_Type_Id = Wt.Work_Type_Id;