APPS.HR_LOC_BUS dependencies on PAY_WC_FUNDS

Line 877: -- pay_wc_funds

873: -- - Checks that the following tables do not reference the hr_locations_all
874: -- row
875: --
876: -- per_all_assigments_f
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)

Line 920: cursor csr_pay_wc_funds 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
922: FROM pay_wc_funds
923: WHERE location_id = p_location_id;
924: --

Line 922: FROM pay_wc_funds

918: WHERE location_id = p_location_id;
919: --
920: cursor csr_pay_wc_funds IS
921: SELECT NULL
922: FROM pay_wc_funds
923: WHERE location_id = p_location_id;
924: --
925: cursor csr_per_events IS
926: SELECT NULL

Line 989: OPEN csr_pay_wc_funds;

985: CLOSE csr_per_all_assignments_f;
986: --
987: --
988: hr_utility.set_location(l_proc, 15);
989: OPEN csr_pay_wc_funds;
990: FETCH csr_pay_wc_funds INTO l_exists;
991: IF csr_pay_wc_funds%found THEN
992: CLOSE csr_pay_wc_funds ;
993: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 990: FETCH csr_pay_wc_funds INTO l_exists;

986: --
987: --
988: hr_utility.set_location(l_proc, 15);
989: OPEN csr_pay_wc_funds;
990: FETCH csr_pay_wc_funds INTO l_exists;
991: IF csr_pay_wc_funds%found THEN
992: CLOSE csr_pay_wc_funds ;
993: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
994: hr_utility.raise_error;

Line 991: IF csr_pay_wc_funds%found THEN

987: --
988: hr_utility.set_location(l_proc, 15);
989: OPEN csr_pay_wc_funds;
990: FETCH csr_pay_wc_funds INTO l_exists;
991: IF csr_pay_wc_funds%found THEN
992: CLOSE csr_pay_wc_funds ;
993: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
994: hr_utility.raise_error;
995: END IF;

Line 992: CLOSE csr_pay_wc_funds ;

988: hr_utility.set_location(l_proc, 15);
989: OPEN csr_pay_wc_funds;
990: FETCH csr_pay_wc_funds INTO l_exists;
991: IF csr_pay_wc_funds%found THEN
992: CLOSE csr_pay_wc_funds ;
993: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
994: hr_utility.raise_error;
995: END IF;
996: CLOSE csr_pay_wc_funds ;

Line 996: CLOSE csr_pay_wc_funds ;

992: CLOSE csr_pay_wc_funds ;
993: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
994: hr_utility.raise_error;
995: END IF;
996: CLOSE csr_pay_wc_funds ;
997: --
998: --
999: hr_utility.set_location(l_proc, 20);
1000: OPEN csr_per_events;