APPS.HR_LOC_BUS dependencies on PER_SALARY_SURVEY_MAPPINGS

Line 872: -- per_salary_survey_mappings

868: -- per_all_vacancies
869: -- hr_all_organization_units
870: -- hr_all_positions_f (date tracked position table)
871: -- pay_element_links_f
872: -- per_salary_survey_mappings
873: -- hr_location_extra_info
874: -- per_us_inval_locations
875: --
876: --

Line 939: cursor csr_per_salary_survey_mappings IS

935: SELECT NULL
936: FROM pay_element_links_f
937: WHERE location_id = p_location_id;
938: --
939: cursor csr_per_salary_survey_mappings IS
940: SELECT NULL
941: FROM per_salary_survey_mappings
942: WHERE location_id = p_location_id;
943:

Line 941: FROM per_salary_survey_mappings

937: WHERE location_id = p_location_id;
938: --
939: cursor csr_per_salary_survey_mappings IS
940: SELECT NULL
941: FROM per_salary_survey_mappings
942: WHERE location_id = p_location_id;
943:
944: cursor csr_hr_location_extra_info IS
945: SELECT NULL

Line 1036: OPEN csr_per_salary_survey_mappings;

1032: CLOSE csr_pay_element_links_f;
1033: --
1034: --
1035: hr_utility.set_location(l_proc, 45);
1036: OPEN csr_per_salary_survey_mappings;
1037: FETCH csr_per_salary_survey_mappings INTO l_exists;
1038: IF csr_per_salary_survey_mappings%found THEN
1039: CLOSE csr_per_salary_survey_mappings;
1040: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1037: FETCH csr_per_salary_survey_mappings INTO l_exists;

1033: --
1034: --
1035: hr_utility.set_location(l_proc, 45);
1036: OPEN csr_per_salary_survey_mappings;
1037: FETCH csr_per_salary_survey_mappings INTO l_exists;
1038: IF csr_per_salary_survey_mappings%found THEN
1039: CLOSE csr_per_salary_survey_mappings;
1040: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1041: hr_utility.raise_error;

Line 1038: IF csr_per_salary_survey_mappings%found THEN

1034: --
1035: hr_utility.set_location(l_proc, 45);
1036: OPEN csr_per_salary_survey_mappings;
1037: FETCH csr_per_salary_survey_mappings INTO l_exists;
1038: IF csr_per_salary_survey_mappings%found THEN
1039: CLOSE csr_per_salary_survey_mappings;
1040: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1041: hr_utility.raise_error;
1042: END IF;

Line 1039: CLOSE csr_per_salary_survey_mappings;

1035: hr_utility.set_location(l_proc, 45);
1036: OPEN csr_per_salary_survey_mappings;
1037: FETCH csr_per_salary_survey_mappings INTO l_exists;
1038: IF csr_per_salary_survey_mappings%found THEN
1039: CLOSE csr_per_salary_survey_mappings;
1040: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1041: hr_utility.raise_error;
1042: END IF;
1043: CLOSE csr_per_salary_survey_mappings;

Line 1043: CLOSE csr_per_salary_survey_mappings;

1039: CLOSE csr_per_salary_survey_mappings;
1040: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1041: hr_utility.raise_error;
1042: END IF;
1043: CLOSE csr_per_salary_survey_mappings;
1044: --
1045: --
1046: hr_utility.set_location(l_proc, 50);
1047: OPEN csr_hr_location_extra_info;