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 190: FROM Pa_Projects_All P

186: /* bug 9132581 changes start: break the statement into two, as P_Max_Project_Id may be null even when P_Min_Project_Id is not null */
187: IF P_Min_Project_Id IS NULL THEN
188: SELECT Min(P.Project_Id) --, Max(P.Project_Id)
189: INTO Min_Project_Id --,Max_Project_Id
190: FROM Pa_Projects_All P
191: WHERE p.org_id = nvl(p_org_id,p.org_id);
192: ELSE
193: Min_Project_Id := P_Min_Project_Id;
194: -- Max_Project_Id := P_Max_Project_Id;

Line 200: FROM Pa_Projects_All P

196:
197: IF P_Max_Project_Id IS NULL THEN
198: SELECT Max(P.Project_Id)
199: INTO Max_Project_Id
200: FROM Pa_Projects_All P
201: WHERE p.org_id = nvl(p_org_id,p.org_id);
202: ELSE
203: Max_Project_Id := P_Max_Project_Id;
204: END IF;

Line 716: FROM pa_projects_all

712:
713:
714: Cursor cur_upg_project is
715: SELECT project_id
716: FROM pa_projects_all
717: WHERE project_id between P_Min_Project_Id and P_Max_Project_Id;
718:
719: /* Added for the bug 14284376 starts */
720: CURSOR cur_ap_po_btc(p_project_id in number)