DBA Data[Home] [Help]

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