APPS.PO_LOCATIONS_S dependencies on HZ_LOCATIONS

Line 45: FROM hz_locations

41: --bug 1942696 hr_location changes to reflect the new view
42: when no_data_found then
43: SELECT location_id
44: INTO X_ship_to_loc_id
45: FROM hz_locations
46: WHERE location_id = X_deliver_to_loc_id;
47: end;
48:
49: /* Check to see if this location is still valid. If so, return TRUE.

Line 64: FROM hz_locations

60: when no_data_found then
61: --bug 1942696 hr_location changes to reflect the new view
62: SELECT location_id
63: INTO X_location_id_v
64: FROM hz_locations
65: WHERE location_id = X_ship_to_loc_id
66: AND sysdate < nvl(address_expiration_date, sysdate + 1);
67: end;
68:

Line 122: FROM HZ_LOCATIONS

118: when no_data_found then
119: --bug 1942696 hr_location changes to reflect the new view
120: SELECT 'location_ok'
121: INTO x_status
122: FROM HZ_LOCATIONS
123: WHERE LOCATION_ID = x_location_id
124: AND NVL(ADDRESS_EXPIRATION_DATE, SYSDATE+1) > SYSDATE;
125: end;
126:

Line 174: from hz_locations

170: select (substrb(rtrim(address1)||'-'||rtrim(city),1,20)) location_code ,
171: null
172: into X_loc_dsp,
173: x_org_id
174: from hz_locations
175: where location_id = X_temp_loc_id;
176: exception
177: when no_data_found then
178: X_loc_dsp := '';

Line 429: FROM HZ_LOCATIONS

425: when no_data_found then
426: --bug 1942696 hr_location changes to reflect the new view
427: SELECT 'Y'
428: INTO X_valid_loc
429: FROM HZ_LOCATIONS
430: WHERE LOCATION_ID = x_location_id
431: AND NVL(ADDRESS_EXPIRATION_DATE, SYSDATE+1) > SYSDATE;
432: end;
433:

Line 486: FROM HZ_LOCATIONS

482: when no_data_found then
483: --bug 1942696 hr_location changes to reflect the new view
484: SELECT 'Y'
485: INTO X_valid_loc
486: FROM HZ_LOCATIONS
487: WHERE LOCATION_ID = x_location_id
488: AND NVL(ADDRESS_EXPIRATION_DATE, SYSDATE+1) > SYSDATE;
489: end;
490:

Line 600: 'FROM hz_locations WHERE ';

596: -- part of hr_location changes new bug 2393886
597:
598: sql_str := 'SELECT (substrb(rtrim(address1)||' || '''-'''||
599: '||rtrim(city),1,20)) location_code, location_id '||
600: 'FROM hz_locations WHERE ';
601:
602: -- IF p_loc_record.location_id IS NOT NULL THEN
603: sql_str := sql_str || 'location_id = :v_loc_id ';
604: loc_id_null := FALSE;

Line 810: /* validate from hz_locations */

806:
807: IF dbms_sql.is_open(X_cid) THEN
808: dbms_sql.close_cursor(X_cid);
809: END IF;
810: /* validate from hz_locations */
811: IF p_loc_record.location_code IS NULL and
812: p_loc_record.location_id IS NOT NULL THEN
813: validate_hz_loc_info(p_loc_record);
814: ELSE

Line 868: X_sql_str := 'select address_expiration_date from hz_locations where ';

864: X_sysdate DATE := sysdate;
865:
866: BEGIN
867:
868: X_sql_str := 'select address_expiration_date from hz_locations where ';
869:
870:
871: IF p_loc_record.location_id IS NOT NULL THEN
872: