APPS.FTE_MLS_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 1844: wsh_trip_stops stops, hr_organization_units org

1840: CURSOR get_org_info_cur (c_stop_id IN NUMBER)
1841: IS
1842: SELECT distinct(org.name) org_name
1843: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1844: wsh_trip_stops stops, hr_organization_units org
1845: WHERE dlegs.delivery_id = dlvy.delivery_id
1846: AND dlegs.pick_up_stop_id = stops.stop_id
1847: AND org.organization_id = dlvy.organization_id
1848: AND stops.stop_id = c_stop_id;

Line 1884: wsh_trip_stops stops, hr_organization_units org,

1880: CURSOR get_org_info_cur (c_trip_id IN NUMBER)
1881: IS
1882: SELECT distinct(org.name) org_name
1883: FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
1884: wsh_trip_stops stops, hr_organization_units org,
1885: wsh_trips trips
1886: WHERE dlegs.delivery_id = dlvy.delivery_id
1887: AND dlegs.pick_up_stop_id = stops.stop_id
1888: AND org.organization_id = dlvy.organization_id

Line 2652: FROM hr_organization_units hou,mtl_parameters mp

2648: BEGIN
2649:
2650: SELECT mp. organization_id
2651: INTO l_organization_id
2652: FROM hr_organization_units hou,mtl_parameters mp
2653: WHERE hou.organization_id = mp.organization_id
2654: AND hou.location_id = p_entity_id
2655: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
2656:

Line 3106: FROM hr_organization_units hou,mtl_parameters mp

3102: l_number_of_errors NUMBER;
3103:
3104: CURSOR GET_ORG_ID_BY_LOCATION (l_stop_loc_id NUMBER) IS
3105: SELECT mp. organization_id
3106: FROM hr_organization_units hou,mtl_parameters mp
3107: WHERE hou.organization_id = mp.organization_id
3108: AND hou.location_id = l_stop_loc_id
3109: AND trunc(sysdate) <= nvl( hou.date_to, trunc(sysdate));
3110: