APPS.PER_CAREER_PATHS_PKG_1 SQL Statements

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

Line: 8

  select 'x'
  from per_career_path_elements
  where career_path_id = p_cpath_id;

Line: 21

     hr_utility.set_message(800, 'PER_7840_DEF_CAR_PATH_DELETE');

Line: 37

  select 'x'
  from per_career_paths
  where business_group_id + 0 = p_bgroup_id
  and upper(name) = upper(p_name)
  and (p_rowid is null
   or (p_rowid is not null and chartorowid(p_rowid) <> rowid));

Line: 66

  select per_career_paths_s.nextval
  from sys.dual;