APPS.MST_CMP_KPIS dependencies on FTE_LOCATION_PARAMETERS
Line 45: fte_location_parameters fte
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;
49: BEGIN