APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on HR_LOCATIONS_ALL

Line 4410: FROM hr_locations_all

4406: ELSIF (p_location_source_table = 'INVENTORY') THEN
4407: BEGIN
4408: SELECT location_id
4409: INTO l_dummy
4410: FROM hr_locations_all
4411: WHERE location_id = p_location_id;
4412: l_return_value := TRUE;
4413: EXCEPTION
4414: WHEN NO_DATA_FOUND THEN

Line 4427: FROM hr_locations_all

4423: -- we first check against HR, if not found then HZ.
4424: BEGIN
4425: SELECT location_id
4426: INTO l_dummy
4427: FROM hr_locations_all
4428: WHERE location_id = p_location_id;
4429: l_return_value := TRUE;
4430: EXCEPTION
4431: WHEN NO_DATA_FOUND THEN

Line 4451: FROM hr_locations_all

4447: ELSIF (p_location_source_table IN ('INTERNAL_SITE','WIP','IN_TRANSIT','PO')) THEN
4448: BEGIN
4449: SELECT location_id
4450: INTO l_dummy
4451: FROM hr_locations_all
4452: WHERE location_id = p_location_id;
4453: l_return_value := TRUE;
4454: EXCEPTION
4455: WHEN NO_DATA_FOUND THEN

Line 4466: FROM hr_locations_all

4462: ELSIF p_location_source_table IN ( 'HR_LOCATIONS') THEN
4463: BEGIN
4464: SELECT location_id
4465: INTO l_dummy
4466: FROM hr_locations_all
4467: WHERE location_id = p_location_id;
4468: l_return_value := TRUE;
4469: EXCEPTION
4470: WHEN NO_DATA_FOUND THEN