APPS.ARH_ADDR_PKG dependencies on HR_LOCATIONS_S

Line 938: select hr_locations_s.nextval into x_location_id from dual;

934: IF x_location_id is null THEN
935: l_count := 1;
936:
937: WHILE l_count > 0 loop
938: select hr_locations_s.nextval into x_location_id from dual;
939:
940: select count(*) into l_count
941: from hz_locations
942: where location_id = x_location_id;

Line 965: select hr_locations_s.nextval into x_location_id from dual;

961:
962: l_count := 1;
963:
964: WHILE l_count > 0 loop
965: select hr_locations_s.nextval into x_location_id from dual;
966:
967: select count(*) into l_count
968: from hz_locations
969: where location_id = x_location_id;