APPS.HR_LOC_BUS dependencies on PAY_ELEMENT_LINKS_F

Line 871: -- pay_element_links_f

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
875: --

Line 934: cursor csr_pay_element_links_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
936: FROM pay_element_links_f
937: WHERE location_id = p_location_id;
938: --

Line 936: FROM pay_element_links_f

932: WHERE location_id = p_location_id;
933: --
934: cursor csr_pay_element_links_f IS
935: SELECT NULL
936: FROM pay_element_links_f
937: WHERE location_id = p_location_id;
938: --
939: cursor csr_per_salary_survey_mappings IS
940: SELECT NULL

Line 1025: OPEN csr_pay_element_links_f;

1021: CLOSE csr_hr_all_positions_f;
1022: --
1023: --
1024: hr_utility.set_location(l_proc, 40);
1025: OPEN csr_pay_element_links_f;
1026: FETCH csr_pay_element_links_f INTO l_exists;
1027: IF csr_pay_element_links_f%found THEN
1028: CLOSE csr_pay_element_links_f;
1029: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1026: FETCH csr_pay_element_links_f INTO l_exists;

1022: --
1023: --
1024: hr_utility.set_location(l_proc, 40);
1025: OPEN csr_pay_element_links_f;
1026: FETCH csr_pay_element_links_f INTO l_exists;
1027: IF csr_pay_element_links_f%found THEN
1028: CLOSE csr_pay_element_links_f;
1029: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1030: hr_utility.raise_error;

Line 1027: IF csr_pay_element_links_f%found THEN

1023: --
1024: hr_utility.set_location(l_proc, 40);
1025: OPEN csr_pay_element_links_f;
1026: FETCH csr_pay_element_links_f INTO l_exists;
1027: IF csr_pay_element_links_f%found THEN
1028: CLOSE csr_pay_element_links_f;
1029: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1030: hr_utility.raise_error;
1031: END IF;

Line 1028: CLOSE csr_pay_element_links_f;

1024: hr_utility.set_location(l_proc, 40);
1025: OPEN csr_pay_element_links_f;
1026: FETCH csr_pay_element_links_f INTO l_exists;
1027: IF csr_pay_element_links_f%found THEN
1028: CLOSE csr_pay_element_links_f;
1029: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1030: hr_utility.raise_error;
1031: END IF;
1032: CLOSE csr_pay_element_links_f;

Line 1032: CLOSE csr_pay_element_links_f;

1028: CLOSE csr_pay_element_links_f;
1029: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1030: hr_utility.raise_error;
1031: END IF;
1032: CLOSE csr_pay_element_links_f;
1033: --
1034: --
1035: hr_utility.set_location(l_proc, 45);
1036: OPEN csr_per_salary_survey_mappings;