6892: -- that looks at csi_item_instances cannot be used directly. Hence calling the
6893: -- same with the location_id.
6894: --
6895: IF p_asset_assignment_tbl(tab_row).fa_sync_validation_reqd = fnd_api.g_true THEN
6896: IF p_instance_tbl(inst_tab_row).location_type_code = 'HZ_PARTY_SITES' THEN
6897: Begin
6898: select location_id
6899: into l_location_id
6900: from HZ_PARTY_SITES
6896: IF p_instance_tbl(inst_tab_row).location_type_code = 'HZ_PARTY_SITES' THEN
6897: Begin
6898: select location_id
6899: into l_location_id
6900: from HZ_PARTY_SITES
6901: where party_site_id = p_instance_tbl(inst_tab_row).location_id;
6902: Exception
6903: when no_data_found then
6904: l_location_id := null;