DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_GRP dependencies on HZ_PARTY_SITES

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

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

Line 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;