APPS.WSH_UTIL_CORE dependencies on HR_ORGANIZATION_UNITS

Line 2275: FROM HR_ORGANIZATION_UNITS HOU

2271: ) RETURN VARCHAR2 IS
2272:
2273: CURSOR org_info IS
2274: SELECT HOU.NAME organization_name
2275: FROM HR_ORGANIZATION_UNITS HOU
2276: WHERE HOU.ORGANIZATION_ID = p_organization_id;
2277:
2278: org_name VARCHAR2(240);
2279:

Line 8103: FROM hr_organization_units hou,mtl_parameters mp

8099: THEN
8100: -- outbound or mixed use first stop location id
8101: SELECT mp. organization_id
8102: INTO l_organization_id
8103: FROM hr_organization_units hou,mtl_parameters mp
8104: WHERE hou.organization_id = mp.organization_id
8105: AND hou.location_id = l_first_stop_loc_id
8106: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
8107: ELSE

Line 8111: FROM hr_organization_units hou,mtl_parameters mp

8107: ELSE
8108: -- inbound so use last stop
8109: SELECT mp. organization_id
8110: INTO l_organization_id
8111: FROM hr_organization_units hou,mtl_parameters mp
8112: WHERE hou.organization_id = mp.organization_id
8113: AND hou.location_id = l_last_stop_loc_id
8114: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
8115: END IF;