DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on HZ_PARTY_SITES

Line 7234: IF p_instance_tbl(inst_tab_row).location_type_code = 'HZ_PARTY_SITES' THEN

7230: -- that looks at csi_item_instances cannot be used directly. Hence calling the
7231: -- same with the location_id.
7232: --
7233: IF p_asset_assignment_tbl(tab_row).fa_sync_validation_reqd = fnd_api.g_true THEN
7234: IF p_instance_tbl(inst_tab_row).location_type_code = 'HZ_PARTY_SITES' THEN
7235: Begin
7236: select location_id
7237: into l_location_id
7238: from HZ_PARTY_SITES

Line 7238: from HZ_PARTY_SITES

7234: IF p_instance_tbl(inst_tab_row).location_type_code = 'HZ_PARTY_SITES' THEN
7235: Begin
7236: select location_id
7237: into l_location_id
7238: from HZ_PARTY_SITES
7239: where party_site_id = p_instance_tbl(inst_tab_row).location_id;
7240: Exception
7241: when no_data_found then
7242: l_location_id := null;