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 2685: FROM hr_all_organization_units

2681: l_vld_organization_id := p_instance_header_tbl(tab_row).vld_organization_id; --bug4754569
2682:
2683: SELECT name
2684: INTO p_instance_header_tbl(tab_row).vld_organization_name
2685: FROM hr_all_organization_units
2686: WHERE organization_id = p_instance_header_tbl(tab_row).vld_organization_id;
2687: EXCEPTION
2688: WHEN OTHERS THEN
2689: null;

Line 4797: FROM hr_all_organization_units

4793: THEN
4794: BEGIN
4795: SELECT location_id
4796: INTO p_instance_rec.location_id
4797: FROM hr_all_organization_units
4798: WHERE organization_id = p_instance_rec.vld_organization_id;
4799: EXCEPTION
4800: WHEN NO_DATA_FOUND THEN
4801: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');

Line 4824: FROM hr_all_organization_units

4820: THEN
4821: BEGIN
4822: SELECT location_id
4823: INTO p_instance_rec.install_location_id
4824: FROM hr_all_organization_units
4825: WHERE organization_id = p_instance_rec.vld_organization_id;
4826: EXCEPTION
4827: WHEN NO_DATA_FOUND THEN
4828: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');

Line 12387: FROM hr_all_organization_units

12383: THEN
12384: BEGIN
12385: SELECT location_id
12386: INTO p_instance_rec.location_id
12387: FROM hr_all_organization_units
12388: WHERE organization_id = p_instance_rec.vld_organization_id;
12389:
12390: l_get_instance_rec.location_id:=p_instance_rec.location_id;
12391:

Line 12417: FROM hr_all_organization_units

12413: THEN
12414: BEGIN
12415: SELECT location_id
12416: INTO p_instance_rec.install_location_id
12417: FROM hr_all_organization_units
12418: WHERE organization_id = p_instance_rec.vld_organization_id;
12419: EXCEPTION
12420: WHEN NO_DATA_FOUND THEN
12421: fnd_message.set_name('CSI','CSI_NO_HR_LOCATIONS');