APPS.PFT_BR_ACT_COST_ROLLUP_PVT SQL Statements

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

Line: 29

PROCEDURE DeleteObjectDefinition(
  p_obj_def_id          in          number
)
--------------------------------------------------------------------------------
IS

  g_api_name    constant varchar2(30)   := 'DeleteObjectDefinition';

Line: 39

  delete from PFT_ACTIVITY_COST_RU
  where cost_rollup_obj_def_id = p_obj_def_id;

Line: 48

END DeleteObjectDefinition;

Line: 80

  insert into pft_activity_cost_ru (
    cost_rollup_obj_def_id
    ,activity_hier_obj_id
    ,currency_code
    ,condition_obj_id
    ,created_by
    ,creation_date
    ,last_updated_by
    ,last_update_date
    ,last_update_login
    ,object_version_number
  ) select
    p_target_obj_def_id
    ,activity_hier_obj_id
    ,currency_code
    ,condition_obj_id
    ,nvl(p_created_by,created_by)
    ,nvl(p_creation_date,creation_date)
    ,FND_GLOBAL.user_id
    ,sysdate
    ,FND_GLOBAL.login_id
    ,object_version_number
  from pft_activity_cost_ru
  where cost_rollup_obj_def_id = p_source_obj_def_id;