APPS.PER_JOB_BUS dependencies on PER_VALID_GRADES

Line 1048: from per_valid_grades vg

1044: procedure check_date_from(p_job_id in number,
1045: p_date_from in date) is
1046: --
1047: cursor csr_date_from is select null
1048: from per_valid_grades vg
1049: where vg.job_id = p_job_id
1050: and p_date_from > vg.date_from;
1051: --
1052: g_dummy_number number;

Line 1087: from per_valid_grades vg

1083: p_early_date_to in out nocopy boolean,
1084: p_early_date_from in out nocopy boolean) is
1085: --
1086: cursor csr_date_to is select null
1087: from per_valid_grades vg
1088: where vg.business_group_id + 0 = p_business_group_id
1089: and vg.job_id = p_job_id
1090: and nvl(vg.date_to, p_end_of_time) > p_date_to;
1091: --

Line 1093: from per_valid_grades vg

1089: and vg.job_id = p_job_id
1090: and nvl(vg.date_to, p_end_of_time) > p_date_to;
1091: --
1092: cursor csr_date_from is select null
1093: from per_valid_grades vg
1094: where vg.business_group_id + 0 = p_business_group_id
1095: and vg.job_id = p_job_id
1096: and vg.date_from > p_date_to;
1097: --

Line 1138: from per_valid_grades vg1

1134: where a.job_id = p_job_id
1135: and a.job_id is not null;
1136: --
1137: cursor csr_grade is select null
1138: from per_valid_grades vg1
1139: where vg1.business_group_id + 0 = p_business_group_id
1140: and vg1.job_id = p_job_id;
1141: --
1142: cursor csr_requirement is select null

Line 1191: -- Check there are no values in per_valid_grades, per_job_requirements,

1187: l_proc varchar2(72) := g_package||'check_delete_record';
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: --