APPS.PA_CAPITAL_PROJECT_UTILS dependencies on PA_PROJECT_ASSET_LINES

Line 30: FROM pa_project_asset_lines pal1

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
32: AND pal1.rev_proj_asset_line_id is null
33: AND NOT EXISTS (select null from pa_project_asset_lines pal2
34: where pal2.project_asset_id = P_asset_id

Line 33: AND NOT EXISTS (select null from pa_project_asset_lines pal2

29: SELECT 'X'
30: FROM pa_project_asset_lines pal1
31: WHERE pal1.project_asset_id = P_Asset_Id
32: AND pal1.rev_proj_asset_line_id is null
33: AND NOT EXISTS (select null from pa_project_asset_lines pal2
34: where pal2.project_asset_id = P_asset_id
35: and pal2.rev_proj_asset_line_id = pal1.project_asset_line_id));
36:
37: RETURN 'Y';

Line 283: from pa_project_asset_lines_all

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:
286: L_Exists Number;
287: