APPS.PFT_BR_ACTIVITY_RATE_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_DRIVER_ASGN
  where activity_rate_obj_def_id = p_obj_def_id;

Line: 42

  delete from PFT_ACTIVITY_RATES
  where activity_rate_obj_def_id = p_obj_def_id;

Line: 51

END DeleteObjectDefinition;

Line: 83

  insert into pft_activity_rates (
    activity_rate_obj_def_id
    ,activity_hier_obj_id
    ,currency_code
    ,condition_obj_id
    ,top_nodes_flag
    ,output_to_rate_stat_flag
    ,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
    ,top_nodes_flag
    ,output_to_rate_stat_flag
    ,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_rates
  where activity_rate_obj_def_id = p_source_obj_def_id;

Line: 114

  insert into pft_activity_driver_asgn (
    activity_rate_obj_def_id
    ,activity_id
    ,source_table_name
    ,column_name
    ,statistic_basis_id
    ,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_id
    ,source_table_name
    ,column_name
    ,statistic_basis_id
    ,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_driver_asgn
  where activity_rate_obj_def_id = p_source_obj_def_id;