APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on HR_LOCATIONS_ALL

Line 4324: FROM hr_locations_all

4320: ELSIF (p_location_source_table = 'INVENTORY') THEN
4321: BEGIN
4322: SELECT location_id
4323: INTO l_dummy
4324: FROM hr_locations_all
4325: WHERE location_id = p_location_id;
4326: l_return_value := TRUE;
4327: EXCEPTION
4328: WHEN NO_DATA_FOUND THEN

Line 4341: FROM hr_locations_all

4337: -- we first check against HR, if not found then HZ.
4338: BEGIN
4339: SELECT location_id
4340: INTO l_dummy
4341: FROM hr_locations_all
4342: WHERE location_id = p_location_id;
4343: l_return_value := TRUE;
4344: EXCEPTION
4345: WHEN NO_DATA_FOUND THEN

Line 4365: FROM hr_locations_all

4361: ELSIF (p_location_source_table IN ('INTERNAL_SITE','WIP','IN_TRANSIT','PO')) THEN
4362: BEGIN
4363: SELECT location_id
4364: INTO l_dummy
4365: FROM hr_locations_all
4366: WHERE location_id = p_location_id;
4367: l_return_value := TRUE;
4368: EXCEPTION
4369: WHEN NO_DATA_FOUND THEN

Line 4380: FROM hr_locations_all

4376: ELSIF p_location_source_table IN ( 'HR_LOCATIONS') THEN
4377: BEGIN
4378: SELECT location_id
4379: INTO l_dummy
4380: FROM hr_locations_all
4381: WHERE location_id = p_location_id;
4382: l_return_value := TRUE;
4383: EXCEPTION
4384: WHEN NO_DATA_FOUND THEN