APPS.FA_DELETION_PVT dependencies on FA_ADDITIONS_B
Line 95: FROM FA_ADDITIONS_B
91: p_asset_desc_rec.lease_id is not null) then
92:
93: SELECT count(*)
94: INTO l_count 95: FROM FA_ADDITIONS_B 96: WHERE LEASE_ID = p_asset_desc_rec.lease_id
97: AND ASSET_CATEGORY_ID =
98: ANY (SELECT CATEGORY_ID
99: FROM FA_CATEGORIES