APPS.PER_CAREER_PATH_ELEMENTS_PKG dependencies on PER_JOBS_V

Line 13: from per_jobs_v

9: p_bgroup_id IN NUMBER) IS
10:
11: cursor c1 is
12: select name
13: from per_jobs_v
14: where job_id = p_child_id;
15: --
16:
17: cursor c2 is

Line 20: from per_jobs_v x,

16:
17: cursor c2 is
18: select x.job_id,
19: x.name
20: from per_jobs_v x,
21: per_career_path_elements y
22: where x.business_group_id + 0 = p_bgroup_id
23: and x.job_id = y.parent_job_id
24: and y.career_path_id = p_cpath_id

Line 111: from per_jobs_v

107: p_sjob_name IN OUT nocopy VARCHAR2) is
108:
109: cursor c5 is
110: select name
111: from per_jobs_v
112: where job_id = p_sjob_id;
113: --
114: begin
115: --