APPS.CSE_FAC_INSERVICE_PKG dependencies on PA_PROJECT_ASSETS_ALL

Line 529: pa_project_assets_all ppa

525: INTO l_pa_project_asset_id,
526: l_date_placed_in_service,
527: l_asset_units
528: FROM pa_project_asset_assignments ppaa,
529: pa_project_assets_all ppa
530: WHERE ppaa.project_id = p_project_id
531: AND ppaa.task_Id = p_task_id
532: AND ppaa.project_asset_id = ppa.project_asset_id
533: AND nvl(ppaa.Attribute6, '**##**') = nvl(exp_line_rec.attribute6, '**##**')

Line 851: UPDATE pa_project_assets_all

847: debug(' pa_project_asset_id : '||l_pa_project_asset_id);
848: debug(' asset_units : '||l_asset_units);
849: debug(' adjusted_units : '||exp_line_rec.quantity);
850:
851: UPDATE pa_project_assets_all
852: SET asset_units = asset_units + exp_line_rec.quantity,
853: date_placed_in_service = nvl(date_placed_in_service, l_date_placed_in_service),
854: project_asset_type = 'AS-BUILT'
855: WHERE project_asset_id = l_pa_project_asset_id;