APPS.EAM_OTL_TIMECARD_PUB dependencies on CSI_ITEM_INSTANCES

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

2007:
2008: -- 3. Asset number belongs to the correct asset group.
2009: if l_asset_number <> ' ' and l_asset_group <> -9999 then
2010: -- Changed as part of CAR impact
2011: select count(*) into l_count from csi_item_instances where
2012: serial_number = l_asset_number and
2013: inventory_item_id = l_asset_group;
2014: if l_count = 0 then
2015: -- Add the corresponding error message to the message table