APPS.HR_LOC_BUS dependencies on PER_SALARY_SURVEY_MAPPINGS

Line 883: -- per_salary_survey_mappings

879: -- per_all_vacancies
880: -- hr_all_organization_units
881: -- hr_all_positions_f (date tracked position table)
882: -- pay_element_links_f
883: -- per_salary_survey_mappings
884: -- hr_location_extra_info
885: -- per_us_inval_locations
886: --
887: --

Line 950: cursor csr_per_salary_survey_mappings IS

946: SELECT NULL
947: FROM pay_element_links_f
948: WHERE location_id = p_location_id;
949: --
950: cursor csr_per_salary_survey_mappings IS
951: SELECT NULL
952: FROM per_salary_survey_mappings
953: WHERE location_id = p_location_id;
954:

Line 952: FROM per_salary_survey_mappings

948: WHERE location_id = p_location_id;
949: --
950: cursor csr_per_salary_survey_mappings IS
951: SELECT NULL
952: FROM per_salary_survey_mappings
953: WHERE location_id = p_location_id;
954:
955: cursor csr_hr_location_extra_info IS
956: SELECT NULL

Line 1056: OPEN csr_per_salary_survey_mappings;

1052: CLOSE csr_pay_element_links_f;
1053: --
1054: --
1055: hr_utility.set_location(l_proc, 45);
1056: OPEN csr_per_salary_survey_mappings;
1057: FETCH csr_per_salary_survey_mappings INTO l_exists;
1058: IF csr_per_salary_survey_mappings%found THEN
1059: CLOSE csr_per_salary_survey_mappings;
1060: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1057: FETCH csr_per_salary_survey_mappings INTO l_exists;

1053: --
1054: --
1055: hr_utility.set_location(l_proc, 45);
1056: OPEN csr_per_salary_survey_mappings;
1057: FETCH csr_per_salary_survey_mappings INTO l_exists;
1058: IF csr_per_salary_survey_mappings%found THEN
1059: CLOSE csr_per_salary_survey_mappings;
1060: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1061: hr_utility.raise_error;

Line 1058: IF csr_per_salary_survey_mappings%found THEN

1054: --
1055: hr_utility.set_location(l_proc, 45);
1056: OPEN csr_per_salary_survey_mappings;
1057: FETCH csr_per_salary_survey_mappings INTO l_exists;
1058: IF csr_per_salary_survey_mappings%found THEN
1059: CLOSE csr_per_salary_survey_mappings;
1060: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1061: hr_utility.raise_error;
1062: END IF;

Line 1059: CLOSE csr_per_salary_survey_mappings;

1055: hr_utility.set_location(l_proc, 45);
1056: OPEN csr_per_salary_survey_mappings;
1057: FETCH csr_per_salary_survey_mappings INTO l_exists;
1058: IF csr_per_salary_survey_mappings%found THEN
1059: CLOSE csr_per_salary_survey_mappings;
1060: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1061: hr_utility.raise_error;
1062: END IF;
1063: CLOSE csr_per_salary_survey_mappings;

Line 1063: CLOSE csr_per_salary_survey_mappings;

1059: CLOSE csr_per_salary_survey_mappings;
1060: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1061: hr_utility.raise_error;
1062: END IF;
1063: CLOSE csr_per_salary_survey_mappings;
1064: --
1065: --
1066: hr_utility.set_location(l_proc, 50);
1067: OPEN csr_hr_location_extra_info;