APPS.FA_DELETION_PUB dependencies on FA_ADD_WARRANTIES
Line 480: DELETE FROM fa_add_warranties
476: WHERE Asset_Id = px_asset_hdr_rec.asset_id;
477:
478: DELETE FROM FA_PERIODIC_PRODUCTION WHERE ASSET_ID = px_asset_hdr_rec.asset_id;
479: 480: DELETE FROM fa_add_warranties 481: WHERE asset_id= px_asset_hdr_rec.asset_id;
482:
483: if ( (fa_cache_pkg.fazcat_record.category_type = 'LEASEHOLD IMPROVEMENT')
484: and (p_asset_desc_rec.lease_id is not null)) then