APPS.EAM_OTL_TIMECARD_PUB dependencies on CSI_ITEM_INSTANCES

Line 2018: select count(*) into l_count from csi_item_instances where

2014:
2015: -- 3. Asset number belongs to the correct asset group.
2016: if l_asset_number <> ' ' and l_asset_group <> -9999 then
2017: -- Changed as part of CAR impact
2018: select count(*) into l_count from csi_item_instances where
2019: serial_number = l_asset_number and
2020: inventory_item_id = l_asset_group;
2021: if l_count = 0 then
2022: -- Add the corresponding error message to the message table