APPS.MST_CMP_KPIS dependencies on WSH_LOCATIONS

Line 44: FROM wsh_locations wl,

40:
41: FUNCTION get_location(p_facility_id IN NUMBER) RETURN NUMBER IS
42: CURSOR cur_location IS
43: SELECT wl.wsh_location_id
44: FROM wsh_locations wl,
45: fte_location_parameters fte
46: WHERE wl.wsh_location_id = fte.location_id
47: AND fte.facility_id = p_facility_id;
48: l_location_id NUMBER;