APPS.PA_ASSET_UTILS dependencies on PA_PROJECT_ASSETS

Line 21: from pa_project_assets

17: x_rowid IN varchar2 ) return number
18: is
19: cursor c1 is
20: select asset_name
21: from pa_project_assets
22: where project_id = x_project_id
23: AND asset_name = x_asset_name
24: AND (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);
25:

Line 24: AND (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);

20: select asset_name
21: from pa_project_assets
22: where project_id = x_project_id
23: AND asset_name = x_asset_name
24: AND (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);
25:
26: c1_rec c1%rowtype;
27:
28: begin

Line 73: from pa_project_assets

69: is
70:
71: cursor c1 is
72: select asset_number
73: from pa_project_assets
74: where asset_number = x_asset_number
75: AND (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);
76:
77: c1_rec c1%rowtype;

Line 75: AND (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);

71: cursor c1 is
72: select asset_number
73: from pa_project_assets
74: where asset_number = x_asset_number
75: AND (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);
76:
77: c1_rec c1%rowtype;
78:
79: begin