APPS.HR_LOC_BUS dependencies on HR_ALL_POSITIONS_F

Line 870: -- hr_all_positions_f (date tracked position table)

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
872: -- per_salary_survey_mappings
873: -- hr_location_extra_info
874: -- per_us_inval_locations

Line 929: cursor csr_hr_all_positions_f IS

925: SELECT NULL
926: FROM hr_all_organization_units
927: WHERE location_id = p_location_id;
928: --
929: cursor csr_hr_all_positions_f IS
930: SELECT NULL
931: FROM hr_all_positions_f
932: WHERE location_id = p_location_id;
933: --

Line 931: FROM hr_all_positions_f

927: WHERE location_id = p_location_id;
928: --
929: cursor csr_hr_all_positions_f IS
930: SELECT NULL
931: FROM hr_all_positions_f
932: WHERE location_id = p_location_id;
933: --
934: cursor csr_pay_element_links_f IS
935: SELECT NULL

Line 1014: OPEN csr_hr_all_positions_f;

1010: --
1011: -- Added by SCNair on 30-SEP-99 (position date tracked table)
1012: --
1013: hr_utility.set_location(l_proc, 35);
1014: OPEN csr_hr_all_positions_f;
1015: FETCH csr_hr_all_positions_f INTO l_exists;
1016: IF csr_hr_all_positions_f%found THEN
1017: CLOSE csr_hr_all_positions_f;
1018: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1015: FETCH csr_hr_all_positions_f INTO l_exists;

1011: -- Added by SCNair on 30-SEP-99 (position date tracked table)
1012: --
1013: hr_utility.set_location(l_proc, 35);
1014: OPEN csr_hr_all_positions_f;
1015: FETCH csr_hr_all_positions_f INTO l_exists;
1016: IF csr_hr_all_positions_f%found THEN
1017: CLOSE csr_hr_all_positions_f;
1018: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1019: hr_utility.raise_error;

Line 1016: IF csr_hr_all_positions_f%found THEN

1012: --
1013: hr_utility.set_location(l_proc, 35);
1014: OPEN csr_hr_all_positions_f;
1015: FETCH csr_hr_all_positions_f INTO l_exists;
1016: IF csr_hr_all_positions_f%found THEN
1017: CLOSE csr_hr_all_positions_f;
1018: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1019: hr_utility.raise_error;
1020: END IF;

Line 1017: CLOSE csr_hr_all_positions_f;

1013: hr_utility.set_location(l_proc, 35);
1014: OPEN csr_hr_all_positions_f;
1015: FETCH csr_hr_all_positions_f INTO l_exists;
1016: IF csr_hr_all_positions_f%found THEN
1017: CLOSE csr_hr_all_positions_f;
1018: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1019: hr_utility.raise_error;
1020: END IF;
1021: CLOSE csr_hr_all_positions_f;

Line 1021: CLOSE csr_hr_all_positions_f;

1017: CLOSE csr_hr_all_positions_f;
1018: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1019: hr_utility.raise_error;
1020: END IF;
1021: CLOSE csr_hr_all_positions_f;
1022: --
1023: --
1024: hr_utility.set_location(l_proc, 40);
1025: OPEN csr_pay_element_links_f;