APPS.HR_LOC_BUS dependencies on HR_ALL_POSITIONS_F

Line 881: -- hr_all_positions_f (date tracked position table)

877: -- pay_wc_funds
878: -- per_events
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

Line 940: cursor csr_hr_all_positions_f IS

936: SELECT NULL
937: FROM hr_all_organization_units
938: WHERE location_id = p_location_id;
939: --
940: cursor csr_hr_all_positions_f IS
941: SELECT NULL
942: FROM hr_all_positions_f
943: WHERE location_id = p_location_id;
944: --

Line 942: FROM hr_all_positions_f

938: WHERE location_id = p_location_id;
939: --
940: cursor csr_hr_all_positions_f IS
941: SELECT NULL
942: FROM hr_all_positions_f
943: WHERE location_id = p_location_id;
944: --
945: cursor csr_pay_element_links_f IS
946: SELECT NULL

Line 1034: OPEN csr_hr_all_positions_f;

1030: --
1031: -- Added by SCNair on 30-SEP-99 (position date tracked table)
1032: --
1033: hr_utility.set_location(l_proc, 35);
1034: OPEN csr_hr_all_positions_f;
1035: FETCH csr_hr_all_positions_f INTO l_exists;
1036: IF csr_hr_all_positions_f%found THEN
1037: CLOSE csr_hr_all_positions_f;
1038: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1035: FETCH csr_hr_all_positions_f INTO l_exists;

1031: -- Added by SCNair on 30-SEP-99 (position date tracked table)
1032: --
1033: hr_utility.set_location(l_proc, 35);
1034: OPEN csr_hr_all_positions_f;
1035: FETCH csr_hr_all_positions_f INTO l_exists;
1036: IF csr_hr_all_positions_f%found THEN
1037: CLOSE csr_hr_all_positions_f;
1038: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1039: hr_utility.raise_error;

Line 1036: IF csr_hr_all_positions_f%found THEN

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

Line 1037: CLOSE csr_hr_all_positions_f;

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

Line 1041: CLOSE csr_hr_all_positions_f;

1037: CLOSE csr_hr_all_positions_f;
1038: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1039: hr_utility.raise_error;
1040: END IF;
1041: CLOSE csr_hr_all_positions_f;
1042: --
1043: --
1044: hr_utility.set_location(l_proc, 40);
1045: OPEN csr_pay_element_links_f;