APPS.CSE_FAC_INSERVICE_PKG dependencies on PA_PROJECT_ASSETS_ALL

Line 516: pa_project_assets_all ppa

512: INTO l_pa_project_asset_id,
513: l_date_placed_in_service,
514: l_asset_units
515: FROM pa_project_asset_assignments ppaa,
516: pa_project_assets_all ppa
517: WHERE ppaa.project_id = p_project_id
518: AND ppaa.task_Id = p_task_id
519: AND ppaa.project_asset_id = ppa.project_asset_id
520: AND nvl(ppaa.Attribute6, '**##**') = nvl(exp_line_rec.attribute6, '**##**')

Line 837: UPDATE pa_project_assets_all

833: debug(' pa_project_asset_id : '||l_pa_project_asset_id);
834: debug(' asset_units : '||l_asset_units);
835: debug(' adjusted_units : '||exp_line_rec.quantity);
836:
837: UPDATE pa_project_assets_all
838: SET asset_units = asset_units + exp_line_rec.quantity,
839: date_placed_in_service = nvl(date_placed_in_service, l_date_placed_in_service),
840: project_asset_type = 'AS-BUILT'
841: WHERE project_asset_id = l_pa_project_asset_id;