APPS.PA_CAPITAL_PROJECT_UTILS dependencies on PA_PROJECT_ASSETS

Line 112: From Pa_Project_Assets

108: Select 1
109: From Dual
110: Where Exists (
111: Select 1
112: From Pa_Project_Assets
113: Where Project_Id = P_Project_Id
114: And Capital_Event_Id = P_Capital_Event_Id
115: And (CAPITALIZED_FLAG = 'N' or
116: (trunc(CAPITALIZED_DATE) < trunc(REVERSAL_DATE)

Line 156: Update Pa_Project_Assets

152: Return Number Is
153:
154: Begin
155:
156: Update Pa_Project_Assets
157: Set Reverse_Flag = 'Y'
158: Where Project_Id = P_Project_Id
159: And Reverse_Flag = 'N'
160: And Capital_Event_Id = P_Capital_Event_Id;

Line 217: from pa_project_assets_all

213: where exists (select tag_number
214: from fa_additions
215: where tag_number = p_tag_number)
216: or exists (select tag_number
217: from pa_project_assets_all
218: where tag_number = p_tag_number);
219:
220: L_Tag_Exists Varchar2(1) := 'N';
221:

Line 424: Where Exists (Select 1 From Pa_Project_Assets_All

420:
421: Cursor EventAssetExist Is
422: Select 'Y'
423: From Dual
424: Where Exists (Select 1 From Pa_Project_Assets_All
425: Where ProjecT_Id = P_Project_Id
426: And Capital_Event_Id = P_Capital_Event_Id);
427:
428: Cursor EventCostExist Is