APPS.FA_DET_ADD_PKG dependencies on FA_ADDITIONS_B

Line 148: from fa_additions_b ad

144: -- ony need to remove the lease for this asset and not all assets that
145: -- have this lease when the asset is being reclassed.
146: if X_Old_Cat_Type = 'LEASE' and X_New_Cat_Type <> 'LEASE' then
147: select count(*) into lv_count
148: from fa_additions_b ad
149: where ad.asset_id = X_Asset_Id
150: and ad.lease_id = X_Lease_Id
151: and exists
152: ( select 'X'