APPS.PA_ASSET_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 20

          select asset_name
	  from pa_project_assets
          where project_id = x_project_id
	  AND	asset_name = x_asset_name
          AND  (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);

Line: 72

          select asset_number
          from pa_project_assets
          where asset_number = x_asset_number
          AND  (x_ROWID IS NULL OR x_ROWID <> pa_project_assets.ROWID);

Line: 119

          select project_asset_id
          from pa_project_asset_lines
          where project_asset_id = x_project_asset_id;

Line: 164

        select distinct faa.asset_number
        from fa_additions faa,
                fa_asset_invoices fai,
                pa_project_asset_lines ppal
        where
                ppal.project_asset_id = pa_asset_id AND
                ppal.project_asset_line_id = fai.project_asset_line_id AND
                fai.asset_id = faa.asset_id;

Line: 191

        SELECT  location_flex_structure
        INTO    x_dummy
        FROM    fa_system_controls;