APPS.PAY_US_DB_PER_SETUP dependencies on HR_LOCATIONS

Line 1924: FROM hr_locations

1920: hr_utility.set_location('pay_us_db_per_setup.create_position',4);
1921: --
1922: SELECT location_id
1923: INTO l_location_id
1924: FROM hr_locations
1925: WHERE location_code = p_location;
1926: --
1927: hr_utility.set_location('pay_us_db_per_setup.create_position',5);
1928: --

Line 2331: select hr_locations_s.nextval

2327: --
2328: hr_utility.trace('Entered Create_us_location');
2329: hr_utility.set_location('scltstdat.create_us_location',1);
2330: --
2331: select hr_locations_s.nextval
2332: into l_location_id
2333: from sys.dual;
2334: --
2335: hr_utility.set_location('scltstdat.create_us_location',5);

Line 2337: INSERT INTO hr_locations

2333: from sys.dual;
2334: --
2335: hr_utility.set_location('scltstdat.create_us_location',5);
2336: --
2337: INSERT INTO hr_locations
2338: (location_id
2339: ,entered_by
2340: ,location_code
2341: ,address_line_1