APPS.CSI_ITEM_INSTANCE_PVT dependencies on HR_LOCATIONS_ALL

Line 2325: FROM hr_locations_all hr

2321: p_instance_header_tbl(tab_row).current_loc_city,
2322: p_instance_header_tbl(tab_row).current_loc_state,
2323: p_instance_header_tbl(tab_row).current_loc_postal_code,
2324: p_instance_header_tbl(tab_row).current_loc_country
2325: FROM hr_locations_all hr
2326: WHERE hr.location_id = p_instance_header_tbl(tab_row).location_id;
2327: EXCEPTION
2328: WHEN OTHERS THEN
2329: NULL;

Line 2350: FROM hr_locations_all hr

2346: p_instance_header_tbl(tab_row).current_loc_city,
2347: p_instance_header_tbl(tab_row).current_loc_state,
2348: p_instance_header_tbl(tab_row).current_loc_postal_code,
2349: p_instance_header_tbl(tab_row).current_loc_country
2350: FROM hr_locations_all hr
2351: WHERE hr.location_id = p_instance_header_tbl(tab_row).location_id;
2352: EXCEPTION
2353: WHEN OTHERS THEN
2354: NULL;

Line 2450: FROM hr_locations_all hr

2446: p_instance_header_tbl(tab_row).current_loc_city,
2447: p_instance_header_tbl(tab_row).current_loc_state,
2448: p_instance_header_tbl(tab_row).current_loc_postal_code,
2449: p_instance_header_tbl(tab_row).current_loc_country
2450: FROM hr_locations_all hr
2451: WHERE hr.location_id = p_instance_header_tbl(tab_row).location_id;
2452: EXCEPTION
2453: WHEN OTHERS THEN
2454: NULL;

Line 2474: FROM hr_locations_all hr

2470: p_instance_header_tbl(tab_row).install_loc_city,
2471: p_instance_header_tbl(tab_row).install_loc_state,
2472: p_instance_header_tbl(tab_row).install_loc_postal_code,
2473: p_instance_header_tbl(tab_row).install_loc_country
2474: FROM hr_locations_all hr
2475: WHERE hr.location_id = p_instance_header_tbl(tab_row).install_location_id;
2476: EXCEPTION
2477: WHEN OTHERS THEN
2478: NULL;