APPS.PO_LOCATIONS_S dependencies on HR_LOCATIONS_ALL

Line 37: FROM hr_locations_all

33:
34: begin
35: SELECT ship_to_location_id
36: INTO X_ship_to_loc_id
37: FROM hr_locations_all
38: WHERE location_id = X_deliver_to_loc_id;
39:
40: exception
41: --bug 1942696 hr_location changes to reflect the new view

Line 56: FROM hr_locations_all

52:
53: begin
54: SELECT location_id
55: INTO X_location_id_v
56: FROM hr_locations_all
57: WHERE location_id = X_ship_to_loc_id
58: AND sysdate < nvl(inactive_date, sysdate + 1);
59: exception
60: when no_data_found then

Line 112: FROM HR_LOCATIONS_ALL

108:
109: begin
110: SELECT 'location_ok'
111: INTO x_status
112: FROM HR_LOCATIONS_ALL
113: WHERE LOCATION_ID = x_location_id
114: AND NVL(INVENTORY_ORGANIZATION_ID, x_organization_id) = x_organization_id
115: AND NVL(INACTIVE_DATE, SYSDATE+1) > SYSDATE;
116:

Line 419: FROM HR_LOCATIONS_ALL

415:
416: begin
417: SELECT 'Y'
418: INTO X_valid_loc
419: FROM HR_LOCATIONS_ALL
420: WHERE LOCATION_ID = x_location_id
421: AND NVL(SHIP_TO_SITE_FLAG,'N') = 'Y'
422: AND NVL(INVENTORY_ORGANIZATION_ID, X_organization_id) = X_organization_id
423: AND NVL(INACTIVE_DATE, SYSDATE+1) > SYSDATE;

Line 476: FROM HR_LOCATIONS_ALL

472:
473: begin
474: SELECT 'Y'
475: INTO X_valid_loc
476: FROM HR_LOCATIONS_ALL
477: WHERE LOCATION_ID = x_location_id
478: AND NVL(RECEIVING_SITE_FLAG,'N') = 'Y'
479: AND NVL(INVENTORY_ORGANIZATION_ID, X_organization_id) = X_organization_id
480: AND NVL(INACTIVE_DATE, SYSDATE+1) > SYSDATE;