eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LOC_BUS dependencies on PAY_ELEMENT_LINKS_F

Line 882: -- pay_element_links_f

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
883: -- per_salary_survey_mappings
884: -- hr_location_extra_info
885: -- per_us_inval_locations
886: --

Line 945: cursor csr_pay_element_links_f IS

941: SELECT NULL
942: FROM hr_all_positions_f
943: WHERE location_id = p_location_id;
944: --
945: cursor csr_pay_element_links_f IS
946: SELECT NULL
947: FROM pay_element_links_f
948: WHERE location_id = p_location_id;
949: --

Line 947: FROM pay_element_links_f

943: WHERE location_id = p_location_id;
944: --
945: cursor csr_pay_element_links_f IS
946: SELECT NULL
947: FROM pay_element_links_f
948: WHERE location_id = p_location_id;
949: --
950: cursor csr_per_salary_survey_mappings IS
951: SELECT NULL

Line 1045: OPEN csr_pay_element_links_f;

1041: CLOSE csr_hr_all_positions_f;
1042: --
1043: --
1044: hr_utility.set_location(l_proc, 40);
1045: OPEN csr_pay_element_links_f;
1046: FETCH csr_pay_element_links_f INTO l_exists;
1047: IF csr_pay_element_links_f%found THEN
1048: CLOSE csr_pay_element_links_f;
1049: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1046: FETCH csr_pay_element_links_f INTO l_exists;

1042: --
1043: --
1044: hr_utility.set_location(l_proc, 40);
1045: OPEN csr_pay_element_links_f;
1046: FETCH csr_pay_element_links_f INTO l_exists;
1047: IF csr_pay_element_links_f%found THEN
1048: CLOSE csr_pay_element_links_f;
1049: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1050: hr_utility.raise_error;

Line 1047: IF csr_pay_element_links_f%found THEN

1043: --
1044: hr_utility.set_location(l_proc, 40);
1045: OPEN csr_pay_element_links_f;
1046: FETCH csr_pay_element_links_f INTO l_exists;
1047: IF csr_pay_element_links_f%found THEN
1048: CLOSE csr_pay_element_links_f;
1049: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1050: hr_utility.raise_error;
1051: END IF;

Line 1048: CLOSE csr_pay_element_links_f;

1044: hr_utility.set_location(l_proc, 40);
1045: OPEN csr_pay_element_links_f;
1046: FETCH csr_pay_element_links_f INTO l_exists;
1047: IF csr_pay_element_links_f%found THEN
1048: CLOSE csr_pay_element_links_f;
1049: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1050: hr_utility.raise_error;
1051: END IF;
1052: CLOSE csr_pay_element_links_f;

Line 1052: CLOSE csr_pay_element_links_f;

1048: CLOSE csr_pay_element_links_f;
1049: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1050: hr_utility.raise_error;
1051: END IF;
1052: CLOSE csr_pay_element_links_f;
1053: --
1054: --
1055: hr_utility.set_location(l_proc, 45);
1056: OPEN csr_per_salary_survey_mappings;