APPS.PA_CAPITAL_PROJECT_UTILS dependencies on DUAL

Line 27: From Dual

23: Begin
24: --check if asset lines have not been reversed
25: Select 1
26: Into l_reversed
27: From Dual
28: where exists (
29: SELECT 'X'
30: FROM pa_project_asset_lines pal1
31: WHERE pal1.project_asset_id = P_Asset_Id

Line 71: From Dual

67: Begin
68: --check if asset line details have been reversed
69: Select 1
70: Into l_reversed
71: From Dual
72: where exists (
73: SELECT 'X'
74: FROM pa_project_asset_line_details pald
75: WHERE pald.expenditure_item_id = P_Ei_Id

Line 106: --existing conditions for not allowing reversal for an individual asset

102: -----------------------------------------------------------------------------------
103: Function Reverse_Event_Allow(P_Project_Id in Number, P_Capital_Event_Id in Number)
104: Return Varchar2 Is
105:
106: --existing conditions for not allowing reversal for an individual asset
107: Cursor C_ReverseAsset Is
108: Select 1
109: From Dual
110: Where Exists (

Line 109: From Dual

105:
106: --existing conditions for not allowing reversal for an individual asset
107: Cursor C_ReverseAsset Is
108: Select 1
109: From Dual
110: Where Exists (
111: Select 1
112: From Pa_Project_Assets
113: Where Project_Id = P_Project_Id

Line 212: select 'Y' from dual

208: Function Tag_Number_Exists(P_Tag_Number in Varchar2)
209: Return Varchar2 Is
210:
211: CURSOR c_tag_exists (p_tag_number in varchar2) is
212: select 'Y' from dual
213: where exists (select tag_number
214: from fa_additions
215: where tag_number = p_tag_number)
216: or exists (select tag_number

Line 281: From Dual

277: Is
278:
279: Cursor C_Asset_Lines_Exist(P_Asset_Id in Number) Is
280: Select 1
281: From Dual
282: Where Exists (select project_asset_id
283: from pa_project_asset_lines_all
284: where project_asset_id = P_Asset_Id);
285:

Line 423: From Dual

419: l_Exist Varchar2(1) := 'N';
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:

Line 430: From Dual

426: And Capital_Event_Id = P_Capital_Event_Id);
427:
428: Cursor EventCostExist Is
429: Select 'Y'
430: From Dual
431: Where Exists (Select 1 From Pa_Expenditure_Items_All
432: Where ProjecT_Id = P_Project_Id
433: And Capital_Event_Id = P_Capital_Event_Id);
434: