APPS.WSH_UTIL_CORE dependencies on HR_ORGANIZATION_UNITS

Line 2283: FROM HR_ORGANIZATION_UNITS HOU

2279: ) RETURN VARCHAR2 IS
2280:
2281: CURSOR org_info IS
2282: SELECT HOU.NAME organization_name
2283: FROM HR_ORGANIZATION_UNITS HOU
2284: WHERE HOU.ORGANIZATION_ID = p_organization_id;
2285:
2286: org_name VARCHAR2(240);
2287:

Line 8139: FROM hr_organization_units hou,mtl_parameters mp

8135: THEN
8136: -- outbound or mixed use first stop location id
8137: SELECT mp. organization_id
8138: INTO l_organization_id
8139: FROM hr_organization_units hou,mtl_parameters mp
8140: WHERE hou.organization_id = mp.organization_id
8141: AND hou.location_id = l_first_stop_loc_id
8142: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
8143: ELSE

Line 8147: FROM hr_organization_units hou,mtl_parameters mp

8143: ELSE
8144: -- inbound so use last stop
8145: SELECT mp. organization_id
8146: INTO l_organization_id
8147: FROM hr_organization_units hou,mtl_parameters mp
8148: WHERE hou.organization_id = mp.organization_id
8149: AND hou.location_id = l_last_stop_loc_id
8150: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
8151: END IF;