APPS.PER_CAREER_PATH_ELEMENTS_PKG SQL Statements

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

Line: 12

select name
from   per_jobs_v
where  job_id = p_child_id;

Line: 18

select x.job_id,
       x.name
from   per_jobs_v x,
       per_career_path_elements y
where  x.business_group_id + 0 = p_bgroup_id
and    x.job_id = y.parent_job_id
and    y.career_path_id = p_cpath_id
and    y.subordinate_job_id = p_child_id;

Line: 55

select per_career_path_elements_s.nextval
from sys.dual;

Line: 79

select 'x'
from per_career_path_elements
where business_group_id + 0 = p_bgroup_id
and career_path_id = p_cpath_id
and parent_job_id = p_sjob_id;

Line: 95

  hr_utility.set_message(801, 'PER_7845_DEF_CAR_MAP_DELETE');

Line: 110

select name
from per_jobs_v
where job_id = p_sjob_id;