APPS.INV_UI_RCV_LOVS dependencies on HZ_LOCATIONS

Line 8491: PROCEDURE get_hr_hz_locations_lov(

8487: WHERE territory_code LIKE p_country || '%'
8488: ORDER BY territory_code;
8489: END GET_COUNTRY_LOV;
8490:
8491: PROCEDURE get_hr_hz_locations_lov(
8492: x_location_codes OUT NOCOPY t_genref,
8493: p_location_code IN VARCHAR2) IS
8494: -- This procedure will return all HR and HZ Active Locations.
8495: -- Added as part of eIB Build; Bug# 4348541

Line 8511: FROM hz_locations hz

8507: 'Y', NVL(clli_code, SUBSTR(city, 1, 10) || SUBSTR(location_id, 1, 10)),
8508: SUBSTR (city, 1, 10)|| SUBSTR (location_id, 1, 10)) location_code,
8509: hz.location_id location_id,
8510: hz.short_description
8511: FROM hz_locations hz
8512: WHERE (SYSDATE BETWEEN NVL(hz.address_effective_date, SYSDATE-1) AND
8513: NVL(hz.address_expiration_date, SYSDATE+1)))
8514: WHERE UPPER(location_code) LIKE UPPER(NVL(p_location_code, location_code)||'%')
8515: ORDER BY location_code;

Line 8516: END get_hr_hz_locations_lov;

8512: WHERE (SYSDATE BETWEEN NVL(hz.address_effective_date, SYSDATE-1) AND
8513: NVL(hz.address_expiration_date, SYSDATE+1)))
8514: WHERE UPPER(location_code) LIKE UPPER(NVL(p_location_code, location_code)||'%')
8515: ORDER BY location_code;
8516: END get_hr_hz_locations_lov;
8517:
8518: --Added for BUG 4309432
8519: PROCEDURE GET_ACTRJTQTY_LOV
8520: (x_actrjtqty_lov OUT NOCOPY t_genref,