APPS.PA_WORK_TYPE_UPGRADE dependencies on PA_PROJECTS_ALL

Line 7: pa_projects_all,

3:
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:

Line 82: From Pa_Projects_All P,

78:
79: Cursor C_Projects Is
80: Select P.Project_Id,
81: Pt.Work_Type_Id
82: From Pa_Projects_All P,
83: Pa_Project_Types_All Pt
84: Where P.Project_Type = Pt.Project_Type
85: And nvl(P.Org_Id, -99) = nvl(Pt.Org_Id, -99)
86: And Pt.Work_Type_Id is not NULL;

Line 141: update pa_projects_all

137: Exit;
138: End If;
139:
140: FORALL i in l_PrjIdTab.first .. l_PrjIdTab.last
141: update pa_projects_all
142: set work_type_id = l_WorkTypeTab(i)
143: where project_id = l_PrjIdTab(i)
144: and work_type_id is null;
145:

Line 189: FROM Pa_Projects_All P

185: -- Get the project range if not supplied
186: IF P_Min_Project_Id IS NULL THEN
187: SELECT Min(P.Project_Id), Max(P.Project_Id)
188: INTO Min_Project_Id,Max_Project_Id
189: FROM Pa_Projects_All P
190: WHERE p.org_id = nvl(p_org_id,p.org_id);
191: ELSE
192: Min_Project_Id := P_Min_Project_Id;
193: Max_Project_Id := P_Max_Project_Id;

Line 694: FROM pa_projects_all

690:
691:
692: Cursor cur_upg_project is
693: SELECT project_id
694: FROM pa_projects_all
695: WHERE project_id between P_Min_Project_Id and P_Max_Project_Id;
696:
697: Begin
698: