APPS.HR_LOC_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 904: cursor csr_per_all_assignments_f IS

900: --
901: --
902: -- Define a cursor for each table in HRMS that contains a location id column.
903: --
904: cursor csr_per_all_assignments_f IS
905: SELECT NULL
906: FROM per_all_assignments_f
907: WHERE location_id = p_location_id;
908: --

Line 906: FROM per_all_assignments_f

902: -- Define a cursor for each table in HRMS that contains a location id column.
903: --
904: cursor csr_per_all_assignments_f IS
905: SELECT NULL
906: FROM per_all_assignments_f
907: WHERE location_id = p_location_id;
908: --
909: cursor csr_pay_wc_funds IS
910: SELECT NULL

Line 958: OPEN csr_per_all_assignments_f;

954: BEGIN
955: hr_utility.set_location('Entering:'|| l_proc, 10);
956: -- get the proposal details first.
957: --
958: OPEN csr_per_all_assignments_f;
959: FETCH csr_per_all_assignments_f INTO l_exists;
960: IF csr_per_all_assignments_f%found THEN
961: CLOSE csr_per_all_assignments_f;
962: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 959: FETCH csr_per_all_assignments_f INTO l_exists;

955: hr_utility.set_location('Entering:'|| l_proc, 10);
956: -- get the proposal details first.
957: --
958: OPEN csr_per_all_assignments_f;
959: FETCH csr_per_all_assignments_f INTO l_exists;
960: IF csr_per_all_assignments_f%found THEN
961: CLOSE csr_per_all_assignments_f;
962: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
963: hr_utility.raise_error;

Line 960: IF csr_per_all_assignments_f%found THEN

956: -- get the proposal details first.
957: --
958: OPEN csr_per_all_assignments_f;
959: FETCH csr_per_all_assignments_f INTO l_exists;
960: IF csr_per_all_assignments_f%found THEN
961: CLOSE csr_per_all_assignments_f;
962: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
963: hr_utility.raise_error;
964: END IF;

Line 961: CLOSE csr_per_all_assignments_f;

957: --
958: OPEN csr_per_all_assignments_f;
959: FETCH csr_per_all_assignments_f INTO l_exists;
960: IF csr_per_all_assignments_f%found THEN
961: CLOSE csr_per_all_assignments_f;
962: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
963: hr_utility.raise_error;
964: END IF;
965: CLOSE csr_per_all_assignments_f;

Line 965: CLOSE csr_per_all_assignments_f;

961: CLOSE csr_per_all_assignments_f;
962: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
963: hr_utility.raise_error;
964: END IF;
965: CLOSE csr_per_all_assignments_f;
966: --
967: --
968: hr_utility.set_location(l_proc, 15);
969: OPEN csr_pay_wc_funds;