DBA Data[Home] [Help]

APPS.PER_JOBS_PKG dependencies on PER_CAREER_PATH_ELEMENTS

Line 255: from per_career_path_elements cpe1

251: from per_job_evaluations jev1
252: where jev1.job_id = p_job_id;
253: --
254: cursor csr_elementp is select null
255: from per_career_path_elements cpe1
256: where cpe1.parent_job_id = p_job_id;
257: --
258: cursor csr_elements is select null
259: from per_career_path_elements cpe1

Line 259: from per_career_path_elements cpe1

255: from per_career_path_elements cpe1
256: where cpe1.parent_job_id = p_job_id;
257: --
258: cursor csr_elements is select null
259: from per_career_path_elements cpe1
260: where cpe1.subordinate_job_id = p_job_id;
261: --
262: cursor csr_budget is select null
263: from per_budget_elements bde1

Line 295: -- per_job_evaluations, per_career_path_elements (check on parent and

291: --
292: begin
293: --
294: -- Check there are no values in per_valid_grades, per_job_requirements,
295: -- per_job_evaluations, per_career_path_elements (check on parent and
296: -- subordinate id), hr_all_positions_f, per_budget_elements,
297: -- PER_all_assignments, per_vacancies_f, per_element_links_f
298: --
299: --