APPS.HR_LOC_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 915: cursor csr_per_all_assignments_f IS

911: --
912: --
913: -- Define a cursor for each table in HRMS that contains a location id column.
914: --
915: cursor csr_per_all_assignments_f IS
916: SELECT NULL
917: FROM per_all_assignments_f
918: WHERE location_id = p_location_id;
919: --

Line 917: FROM per_all_assignments_f

913: -- Define a cursor for each table in HRMS that contains a location id column.
914: --
915: cursor csr_per_all_assignments_f IS
916: SELECT NULL
917: FROM per_all_assignments_f
918: WHERE location_id = p_location_id;
919: --
920: cursor csr_pay_wc_funds IS
921: SELECT NULL

Line 978: OPEN csr_per_all_assignments_f;

974: BEGIN
975: hr_utility.set_location('Entering:'|| l_proc, 10);
976: -- get the proposal details first.
977: --
978: OPEN csr_per_all_assignments_f;
979: FETCH csr_per_all_assignments_f INTO l_exists;
980: IF csr_per_all_assignments_f%found THEN
981: CLOSE csr_per_all_assignments_f;
982: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 979: FETCH csr_per_all_assignments_f INTO l_exists;

975: hr_utility.set_location('Entering:'|| l_proc, 10);
976: -- get the proposal details first.
977: --
978: OPEN csr_per_all_assignments_f;
979: FETCH csr_per_all_assignments_f INTO l_exists;
980: IF csr_per_all_assignments_f%found THEN
981: CLOSE csr_per_all_assignments_f;
982: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
983: hr_utility.raise_error;

Line 980: IF csr_per_all_assignments_f%found THEN

976: -- get the proposal details first.
977: --
978: OPEN csr_per_all_assignments_f;
979: FETCH csr_per_all_assignments_f INTO l_exists;
980: IF csr_per_all_assignments_f%found THEN
981: CLOSE csr_per_all_assignments_f;
982: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
983: hr_utility.raise_error;
984: END IF;

Line 981: CLOSE csr_per_all_assignments_f;

977: --
978: OPEN csr_per_all_assignments_f;
979: FETCH csr_per_all_assignments_f INTO l_exists;
980: IF csr_per_all_assignments_f%found THEN
981: CLOSE csr_per_all_assignments_f;
982: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
983: hr_utility.raise_error;
984: END IF;
985: CLOSE csr_per_all_assignments_f;

Line 985: CLOSE csr_per_all_assignments_f;

981: CLOSE csr_per_all_assignments_f;
982: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
983: hr_utility.raise_error;
984: END IF;
985: CLOSE csr_per_all_assignments_f;
986: --
987: --
988: hr_utility.set_location(l_proc, 15);
989: OPEN csr_pay_wc_funds;