DBA Data[Home] [Help]

APPS.PA_CAPITAL_PROJECT_UTILS dependencies on PA_PROJECT_ASSETS_ALL

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