161: check_asset_number IN VARCHAR2) return number is
162:
163: cursor c1 (pa_asset_id NUMBER) is
164: select distinct faa.asset_number
165: from fa_additions faa,
166: fa_asset_invoices fai,
167: pa_project_asset_lines ppal
168: where
169: ppal.project_asset_id = pa_asset_id AND