APPS.HR_LOC_BUS dependencies on PER_EVENTS

Line 867: -- per_events

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)
871: -- pay_element_links_f

Line 914: cursor csr_per_events 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
916: FROM per_events
917: WHERE location_id = p_location_id;
918: --

Line 916: FROM per_events

912: WHERE location_id = p_location_id;
913: --
914: cursor csr_per_events IS
915: SELECT NULL
916: FROM per_events
917: WHERE location_id = p_location_id;
918: --
919: cursor csr_per_all_vacancies IS
920: SELECT NULL

Line 980: OPEN csr_per_events;

976: CLOSE csr_pay_wc_funds ;
977: --
978: --
979: hr_utility.set_location(l_proc, 20);
980: OPEN csr_per_events;
981: FETCH csr_per_events INTO l_exists;
982: IF csr_per_events%found THEN
983: CLOSE csr_per_events;
984: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 981: FETCH csr_per_events INTO l_exists;

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

Line 982: IF csr_per_events%found THEN

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

Line 983: CLOSE csr_per_events;

979: hr_utility.set_location(l_proc, 20);
980: OPEN csr_per_events;
981: FETCH csr_per_events INTO l_exists;
982: IF csr_per_events%found THEN
983: CLOSE csr_per_events;
984: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
985: hr_utility.raise_error;
986: END IF;
987: CLOSE csr_per_events;

Line 987: CLOSE csr_per_events;

983: CLOSE csr_per_events;
984: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
985: hr_utility.raise_error;
986: END IF;
987: CLOSE csr_per_events;
988: --
989: --
990: hr_utility.set_location(l_proc, 25);
991: OPEN csr_per_all_vacancies;