APPS.INV_UI_RCV_LOVS dependencies on HZ_LOCATIONS

Line 7431: PROCEDURE get_hr_hz_locations_lov(

7427: WHERE territory_code LIKE p_country || '%'
7428: ORDER BY territory_code;
7429: END GET_COUNTRY_LOV;
7430:
7431: PROCEDURE get_hr_hz_locations_lov(
7432: x_location_codes OUT NOCOPY t_genref,
7433: p_location_code IN VARCHAR2) IS
7434: -- This procedure will return all HR and HZ Active Locations.
7435: -- Added as part of eIB Build; Bug# 4348541

Line 7451: FROM hz_locations hz

7447: 'Y', NVL(clli_code, SUBSTR(city, 1, 10) || SUBSTR(location_id, 1, 10)),
7448: SUBSTR (city, 1, 10)|| SUBSTR (location_id, 1, 10)) location_code,
7449: hz.location_id location_id,
7450: hz.short_description
7451: FROM hz_locations hz
7452: WHERE (SYSDATE BETWEEN NVL(hz.address_effective_date, SYSDATE-1) AND
7453: NVL(hz.address_expiration_date, SYSDATE+1)))
7454: WHERE UPPER(location_code) LIKE UPPER(NVL(p_location_code, location_code)||'%')
7455: ORDER BY location_code;

Line 7456: END get_hr_hz_locations_lov;

7452: WHERE (SYSDATE BETWEEN NVL(hz.address_effective_date, SYSDATE-1) AND
7453: NVL(hz.address_expiration_date, SYSDATE+1)))
7454: WHERE UPPER(location_code) LIKE UPPER(NVL(p_location_code, location_code)||'%')
7455: ORDER BY location_code;
7456: END get_hr_hz_locations_lov;
7457:
7458: --Added for BUG 4309432
7459: PROCEDURE GET_ACTRJTQTY_LOV
7460: (x_actrjtqty_lov OUT NOCOPY t_genref,