APPS.HR_LOC_BUS dependencies on PER_EVENTS

Line 878: -- per_events

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

Line 925: cursor csr_per_events 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
927: FROM per_events
928: WHERE location_id = p_location_id;
929: --

Line 927: FROM per_events

923: WHERE location_id = p_location_id;
924: --
925: cursor csr_per_events IS
926: SELECT NULL
927: FROM per_events
928: WHERE location_id = p_location_id;
929: --
930: cursor csr_per_all_vacancies IS
931: SELECT NULL

Line 1000: OPEN csr_per_events;

996: CLOSE csr_pay_wc_funds ;
997: --
998: --
999: hr_utility.set_location(l_proc, 20);
1000: OPEN csr_per_events;
1001: FETCH csr_per_events INTO l_exists;
1002: IF csr_per_events%found THEN
1003: CLOSE csr_per_events;
1004: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1001: FETCH csr_per_events INTO l_exists;

997: --
998: --
999: hr_utility.set_location(l_proc, 20);
1000: OPEN csr_per_events;
1001: FETCH csr_per_events INTO l_exists;
1002: IF csr_per_events%found THEN
1003: CLOSE csr_per_events;
1004: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1005: hr_utility.raise_error;

Line 1002: IF csr_per_events%found THEN

998: --
999: hr_utility.set_location(l_proc, 20);
1000: OPEN csr_per_events;
1001: FETCH csr_per_events INTO l_exists;
1002: IF csr_per_events%found THEN
1003: CLOSE csr_per_events;
1004: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1005: hr_utility.raise_error;
1006: END IF;

Line 1003: CLOSE csr_per_events;

999: hr_utility.set_location(l_proc, 20);
1000: OPEN csr_per_events;
1001: FETCH csr_per_events INTO l_exists;
1002: IF csr_per_events%found THEN
1003: CLOSE csr_per_events;
1004: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1005: hr_utility.raise_error;
1006: END IF;
1007: CLOSE csr_per_events;

Line 1007: CLOSE csr_per_events;

1003: CLOSE csr_per_events;
1004: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1005: hr_utility.raise_error;
1006: END IF;
1007: CLOSE csr_per_events;
1008: --
1009: --
1010: hr_utility.set_location(l_proc, 25);
1011: OPEN csr_per_all_vacancies;