APPS.CSI_ITEM_INSTANCE_PVT dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1838: FROM hr_all_organization_units

1834: THEN
1835: BEGIN
1836: SELECT location_id
1837: INTO x_instance_rec.location_id
1838: FROM hr_all_organization_units
1839: WHERE organization_id = x_instance_rec.vld_organization_id;
1840: EXCEPTION
1841: WHEN NO_DATA_FOUND THEN
1842: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');

Line 2194: FROM hr_all_organization_units

2190: IF p_instance_header_tbl(tab_row).location_type_code = 'INVENTORY' THEN
2191: BEGIN
2192: SELECT name
2193: INTO p_instance_header_tbl(tab_row).inv_organization_name
2194: FROM hr_all_organization_units
2195: WHERE organization_id = p_instance_header_tbl(tab_row).inv_organization_id;
2196: EXCEPTION
2197: WHEN OTHERS THEN
2198: null;

Line 2704: FROM hr_all_organization_units

2700: l_vld_organization_id := p_instance_header_tbl(tab_row).vld_organization_id; --bug4754569
2701:
2702: SELECT name
2703: INTO p_instance_header_tbl(tab_row).vld_organization_name
2704: FROM hr_all_organization_units
2705: WHERE organization_id = p_instance_header_tbl(tab_row).vld_organization_id;
2706: EXCEPTION
2707: WHEN OTHERS THEN
2708: null;

Line 4828: FROM hr_all_organization_units

4824: THEN
4825: BEGIN
4826: SELECT location_id
4827: INTO p_instance_rec.location_id
4828: FROM hr_all_organization_units
4829: WHERE organization_id = p_instance_rec.vld_organization_id;
4830: EXCEPTION
4831: WHEN NO_DATA_FOUND THEN
4832: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');

Line 4855: FROM hr_all_organization_units

4851: THEN
4852: BEGIN
4853: SELECT location_id
4854: INTO p_instance_rec.install_location_id
4855: FROM hr_all_organization_units
4856: WHERE organization_id = p_instance_rec.vld_organization_id;
4857: EXCEPTION
4858: WHEN NO_DATA_FOUND THEN
4859: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');

Line 12728: FROM hr_all_organization_units

12724: THEN
12725: BEGIN
12726: SELECT location_id
12727: INTO p_instance_rec.location_id
12728: FROM hr_all_organization_units
12729: WHERE organization_id = p_instance_rec.vld_organization_id;
12730:
12731: l_get_instance_rec.location_id:=p_instance_rec.location_id;
12732:

Line 12758: FROM hr_all_organization_units

12754: THEN
12755: BEGIN
12756: SELECT location_id
12757: INTO p_instance_rec.install_location_id
12758: FROM hr_all_organization_units
12759: WHERE organization_id = p_instance_rec.vld_organization_id;
12760: EXCEPTION
12761: WHEN NO_DATA_FOUND THEN
12762: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');