DBA Data[Home] [Help]

APPS.PER_JOB_BUS dependencies on PER_CAREER_PATH_ELEMENTS

Line 1151: from per_career_path_elements cpe1

1147: from per_job_evaluations jev1
1148: where jev1.job_id = p_job_id;
1149: --
1150: cursor csr_elementp is select null
1151: from per_career_path_elements cpe1
1152: where cpe1.parent_job_id = p_job_id;
1153: --
1154: cursor csr_elements is select null
1155: from per_career_path_elements cpe1

Line 1155: from per_career_path_elements cpe1

1151: from per_career_path_elements cpe1
1152: where cpe1.parent_job_id = p_job_id;
1153: --
1154: cursor csr_elements is select null
1155: from per_career_path_elements cpe1
1156: where cpe1.subordinate_job_id = p_job_id;
1157: --
1158: cursor csr_budget is select null
1159: from per_budget_elements bde1

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

1188: --
1189: begin
1190: --
1191: -- Check there are no values in per_valid_grades, per_job_requirements,
1192: -- per_job_evaluations, per_career_path_elements (check on parent and
1193: -- subordinate id), hr_all_positions_f, per_budget_elements,
1194: -- PER_all_assignments, per_vacancies_f, per_element_links_f
1195: --
1196: --