APPS.WSH_MAPPING_DATA dependencies on HR_LOCATIONS_ALL

Line 461: HR_LOCATIONS_ALL HL

457: HL.TELEPHONE_NUMBER_1 TELEPHONE,
458: NULL URL
459: FROM
460: wsh_ship_from_org_locations_v WSFL,
461: HR_LOCATIONS_ALL HL
462: WHERE
463: WSFL.wsh_location_id = p_loc_id
464: AND WSFL.source_location_id = HL.location_id;
465:

Line 2413: hr_locations_all hl

2409: wsfl.postal_code postal_code,
2410: wsfl.province region,
2411: wsfl.state state
2412: FROM wsh_ship_from_org_locations_v wsfl,
2413: hr_locations_all hl
2414: WHERE wsfl.wsh_location_id = c_loc_id
2415: AND wsfl.source_location_id = hl.location_id;
2416:
2417: CURSOR ship_to_info_cur(c_loc_id NUMBER, c_opUnit_id NUMBER DEFAULT NULL) IS