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 PER_US_INVAL_LOCATIONS

Line 885: -- per_us_inval_locations

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: --
887: --
888: -- Pre-conditions:
889: -- None

Line 960: cursor csr_per_us_inval_locations IS

956: SELECT NULL
957: FROM hr_location_extra_info
958: WHERE location_id = p_location_id;
959: --
960: cursor csr_per_us_inval_locations IS
961: SELECT NULL
962: FROM per_us_inval_locations
963: WHERE location_id = p_location_id;
964:

Line 962: FROM per_us_inval_locations

958: WHERE location_id = p_location_id;
959: --
960: cursor csr_per_us_inval_locations IS
961: SELECT NULL
962: FROM per_us_inval_locations
963: WHERE location_id = p_location_id;
964:
965: --- Fix For Bug 7644045 Starts ---
966: cursor csr_legal_location_flag is

Line 1078: OPEN csr_per_us_inval_locations;

1074: CLOSE csr_hr_location_extra_info;
1075: --
1076: --
1077: hr_utility.set_location(l_proc, 55);
1078: OPEN csr_per_us_inval_locations;
1079: FETCH csr_per_us_inval_locations INTO l_exists;
1080: IF csr_per_us_inval_locations%found THEN
1081: CLOSE csr_per_us_inval_locations;
1082: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');

Line 1079: FETCH csr_per_us_inval_locations INTO l_exists;

1075: --
1076: --
1077: hr_utility.set_location(l_proc, 55);
1078: OPEN csr_per_us_inval_locations;
1079: FETCH csr_per_us_inval_locations INTO l_exists;
1080: IF csr_per_us_inval_locations%found THEN
1081: CLOSE csr_per_us_inval_locations;
1082: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1083: hr_utility.raise_error;

Line 1080: IF csr_per_us_inval_locations%found THEN

1076: --
1077: hr_utility.set_location(l_proc, 55);
1078: OPEN csr_per_us_inval_locations;
1079: FETCH csr_per_us_inval_locations INTO l_exists;
1080: IF csr_per_us_inval_locations%found THEN
1081: CLOSE csr_per_us_inval_locations;
1082: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1083: hr_utility.raise_error;
1084: END IF;

Line 1081: CLOSE csr_per_us_inval_locations;

1077: hr_utility.set_location(l_proc, 55);
1078: OPEN csr_per_us_inval_locations;
1079: FETCH csr_per_us_inval_locations INTO l_exists;
1080: IF csr_per_us_inval_locations%found THEN
1081: CLOSE csr_per_us_inval_locations;
1082: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1083: hr_utility.raise_error;
1084: END IF;
1085: CLOSE csr_per_us_inval_locations;

Line 1085: CLOSE csr_per_us_inval_locations;

1081: CLOSE csr_per_us_inval_locations;
1082: hr_utility.set_message(800, 'PER_52506_CHK_DEL_LOCATION');
1083: hr_utility.raise_error;
1084: END IF;
1085: CLOSE csr_per_us_inval_locations;
1086: --
1087: --- Fix For Bug 7644045 Starts ---
1088: OPEN csr_legal_location_flag ;
1089: FETCH csr_legal_location_flag INTO l_exists;