APPS.HR_LOC_BUS dependencies on PAY_WC_FUNDS

Line 866: -- pay_wc_funds

862: -- - Checks that the following tables do not reference the hr_locations_all
863: -- row
864: --
865: -- per_all_assigments_f
866: -- pay_wc_funds
867: -- per_events
868: -- per_all_vacancies
869: -- hr_all_organization_units
870: -- hr_all_positions_f (date tracked position table)

Line 909: cursor csr_pay_wc_funds 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
911: FROM pay_wc_funds
912: WHERE location_id = p_location_id;
913: --

Line 911: FROM pay_wc_funds

907: WHERE location_id = p_location_id;
908: --
909: cursor csr_pay_wc_funds IS
910: SELECT NULL
911: FROM pay_wc_funds
912: WHERE location_id = p_location_id;
913: --
914: cursor csr_per_events IS
915: SELECT NULL

Line 969: OPEN csr_pay_wc_funds;

965: CLOSE csr_per_all_assignments_f;
966: --
967: --
968: hr_utility.set_location(l_proc, 15);
969: OPEN csr_pay_wc_funds;
970: FETCH csr_pay_wc_funds INTO l_exists;
971: IF csr_pay_wc_funds%found THEN
972: CLOSE csr_pay_wc_funds ;
973: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 970: FETCH csr_pay_wc_funds INTO l_exists;

966: --
967: --
968: hr_utility.set_location(l_proc, 15);
969: OPEN csr_pay_wc_funds;
970: FETCH csr_pay_wc_funds INTO l_exists;
971: IF csr_pay_wc_funds%found THEN
972: CLOSE csr_pay_wc_funds ;
973: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
974: hr_utility.raise_error;

Line 971: IF csr_pay_wc_funds%found THEN

967: --
968: hr_utility.set_location(l_proc, 15);
969: OPEN csr_pay_wc_funds;
970: FETCH csr_pay_wc_funds INTO l_exists;
971: IF csr_pay_wc_funds%found THEN
972: CLOSE csr_pay_wc_funds ;
973: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
974: hr_utility.raise_error;
975: END IF;

Line 972: CLOSE csr_pay_wc_funds ;

968: hr_utility.set_location(l_proc, 15);
969: OPEN csr_pay_wc_funds;
970: FETCH csr_pay_wc_funds INTO l_exists;
971: IF csr_pay_wc_funds%found THEN
972: CLOSE csr_pay_wc_funds ;
973: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
974: hr_utility.raise_error;
975: END IF;
976: CLOSE csr_pay_wc_funds ;

Line 976: CLOSE csr_pay_wc_funds ;

972: CLOSE csr_pay_wc_funds ;
973: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
974: hr_utility.raise_error;
975: END IF;
976: CLOSE csr_pay_wc_funds ;
977: --
978: --
979: hr_utility.set_location(l_proc, 20);
980: OPEN csr_per_events;